Forum Discussion
Snowflake DirectQuery incredibly slow on Power BI Desktop, yet works fine in Power BI Service
Thanks for your response v-diye-msft. I actually had it enabled at first and just tried disabling all the options.
Turns out the slowness was caused by these automatically added parameters in Power Query:
[CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]
After removing these, the performance is back to normal.
Hi tahga
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 the query, please fetch the Fiddler Trace and create a support ticket for deep analysis.
Thanks for your response v-diye-msft. I actually had it enabled at first and just tried disabling all the options.
Turns out the slowness was caused by these automatically added parameters in Power Query:
[CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]
After removing these, the performance is back to normal.
I went into the advanced editor and I don't see those paramters. I don't see them under parameters either. I also have the Parallel loading of tables enabled.
