Problem in direct query:very slow to refresh preview

[dmoysidis]

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?

[MohammadSalman]

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

[v-sihou-msft]

@dmoysidis

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,

[GilbertQ]

Hi @dmoysidis

What happens if you had to remove the filter? It appears that you have got a filter in your step as shown in your screenshot below.

[dmoysidis]

Tried that but without any luck. 30min waiting and CPU at 99% as well as RAM at 99%

[dmoysidis · Accepted solution]

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.