I inherited an Excel data model consisting of multiple workbooks. Each workbook has multiple tabs utilizing Power Queries to get, transform and load data sets from base supporting Excel and csv files.
Over time the files of the model have grown tremendously (upwards of 30MB) in size causing Excel to hang or crash. It has only been recently that I discovered Excel Power Query has a file size limitation of 10MB.
I am now considering a redesign of the model using Microsoft Power BI and want to know if there are any such limitations that will need to be considered.