Forum Discussion
Solved
Apply Query Changes ran multiple times
Hi all, I'm loading a simple query like "select * from view_" (over 4 million rows in total) from SQL server in PowerBI Desktop and it runs multiple times. I've tested with a subset of that view,...
Well, I removed the two "rename columns" steps and then refreshed the report, it only ran once. Not sure if this was the reason for loading data twice, but if you come across the same issue, it's worth giving it a try.
Hi, ivy8252003
Based on your description, I think your query should run once. It is possible that Power Query try to get the type of data according to the first 1k rows. You may try to go to 'File'-'Options'-'Current File'-'Data Load', uncheck 'Automatically detect column types and headers for unstuctured sources'.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.