Forum Discussion
michaelshparber
Advocate V
Advocate VStop Power Query from reloading from source each step while editing
I am connecting to Salesforce. The first three steps including Navigation and Expand of one of Subtables take approx. 10-15 seconds to show the first 1000 rows. Now when I add simple steps, like fi...
nandukrishnavs
Community Champion
Community Champion
If you apply any changes in EditQuery it will refresh the preview automatically and when you click close & apply the table and related tables will be refreshed. The loading time will depend on your network and type of source etc. You could try data dataflow https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-create-use. Since it is a cloud service, the load time will be improved.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂