Forum Discussion
Load limit for an Excel data source limits data in the PowerBi Service too
My data source is a huge local Excel file. I use a power query parameter to limit the data load locally but when I publish, only the loaded data seems to get published. As a result, it makes no diffe...
It's actually not that huge: 65K rows in a 40MB file. Yet PBI Desktop struggles forever while an R script handles it with ease on the same laptop.
It really shouldn't be having a problem with that size unless you are doing a bunch of wild transformation on it, or perhaps your computer is lacking resources (Power BI uses a lot of system resources). It might help if you posted the advanced query text so people can see what's going on in the query.