Forum Discussion

tahga's avatar
tahga
Frequent Visitor
6 years ago
Solved

Snowflake DirectQuery incredibly slow on Power BI Desktop, yet works fine in Power BI Service

It is near impossible at the moment to develop direct query reports on Snowflake with Power BI Desktop. I'm running the latest version of Power BI Desktop (9/2019) and Snowflake ODBC driver (2.19.14....
Need Help
  • tahga's avatar
    tahga
    6 years ago

    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.

tahga's avatar
tahga
Frequent Visitor
6 years ago

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.

PAPutzback2's avatar
PAPutzback2
Helper II
5 years ago

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.