Forum Discussion
Load limit for an Excel data source limits data in the PowerBi Service too
How big are we talking? The swapping parameters like that is a technique that people use to make changes locally without stressing their computer / taking a long time, then refreshing in the service. If it's too big to refresh locally, it's likely going to be too big in the service also, and SharePoint will not make it faster either. If it's a truly large file, putting it in a database (SQL) is your best option.
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.