Forum Discussion
Power Query Editor REALLY SLOW - SQL SERVER CONNECTION
Hi Anonymous ,
Which connection mode you are using to connect SQL Server? Import or Direct Query? Is the underlying database running smoothly? It is difficult to give a suitable solution without sample data and related execution operations. Because there are many possible reasons(large amount of data, specific applied steps etc.)... You can try the following operations anyway and see if the situation has improved later:
1. Upgrade your Power BI Desktop to the latest version
2. Uncheck background data (File –> Options –>Data Load –>Allow data previews to download in the background)Any way to speed up really slow refresh times in Power Query?
3. Refer the following blog to update/optimize the reportTransformations in Power Query - Very Slow Performance
Best Regards
Hi Anonymous ,
Which connection mode you are using to connect SQL Server? Import or Direct Query? Is the underlying database running smoothly? It is difficult to give a suitable solution without sample data and related execution operations. Because there are many possible reasons(large amount of data, specific applied steps etc.)... You can try the following operations anyway and see if the situation has improved later:
1. Upgrade your Power BI Desktop to the latest version
2. Uncheck background data (File –> Options –>Data Load –>Allow data previews to download in the background)
Any way to speed up really slow refresh times in Power Query?
3. Refer the following blog to update/optimize the report
Transformations in Power Query - Very Slow Performance
Best Regards