Forum Discussion
Problem in direct query:very slow to refresh preview
Before updating to the latest version of Power BI my reports were fine. Now at the query editor, I have to wait hours (!) for the refresh to show any results.
I am connecting to CRM Dynamics Online 8.2
Any idea what's happening?
OK so I created a new query and copied the code and practically generated the same result and the preview loaded in 5 seconds. So if we created a query with an old version then that's not compatible with the new and we have to re-generate it?
That doesn't make any sense at all.
5 Replies
Tried that but without any luck. 30min waiting and CPU at 99% as well as RAM at 99%
OK so I created a new query and copied the code and practically generated the same result and the preview loaded in 5 seconds. So if we created a query with an old version then that's not compatible with the new and we have to re-generate it?
That doesn't make any sense at all.
v-sihou-msftMicrosoft Employee
Make sure you enable parallel loading tables.
And verify your Power Query to see if there's any Query Fold issue.
Not Folding; the Black Hole of Power Query Performance
If there's no issue on query, please fetch the Fiddler Trace and create a support ticket for deep analysis.
Regards,
Hello,
Did you manage to know what the reason behind this issue is? I am having the same issue were I have 11 queries and sometimes some of them are loaded successfully and sometimes none of them is being loaded. All data sources are excel sheets (some locally and some stored on BOX).
PLEASE HELP 😞
Thanks,
Mohammad
