Forum Discussion
Sound advice on improving Query Refresh
Is there any sound advice on uploading large datasets (5 million rows from SQL server 2016) into Power BI? It is tough for me to aggregate the data as I need it at the granular level. I removed my ...
Correct and hopefully it will be part of your long-term solution otherwise the refresh will take as long as the initial load.
Other things to consider : query folding,
auto date/time settings,
not returning fields from the db that are not required,
using table.buffer if the same table is being loaded repeatedly in query transformations,
what's going on in the db when the load is being run, and so on
Hi Anonymous ，
Loading large dataset in import mode always takes a lot of time. Do you consider to use DirectQuery mode instead?
Best Regards,
Jay