Forum Discussion

sdata5's avatar
sdata5
Regular Visitor
4 years ago

Power BI desktop data import is slow when using Snowflake Connectors

Hi,   I am using Power BI Desktop (Version - 2.104.702.0 64-bit (April 2022)) and importing data from Snowflake tables using ODBC (Version 2.24.07.00) connection and custom query which pulls approx...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi sdata5 ,

First, please check if your computer meets the minimum requirements to run Power BI Desktop.

  • Windows 8.1 / Windows Server 2012 R2, or later
  • .NET 4.6.2 or later
  • Internet Explorer 11 or later
  • Memory (RAM): At least 2 GB available, 4 GB or more recommended.
  • Display: At least 1440x900 or 1600x900 (16:9) required. Lower resolutions such as 1024x768 or 1280x800 aren't supported, as certain controls (such as closing the startup screen) display beyond those resolutions.
  • Windows display settings: If you set your display settings to change the size of text, apps, and other items to more than 100%, you may not be able to see certain dialogs that you must interact with to continue using Power BI Desktop. If you encounter this issue, check your display settings in Windows by going to Settings > System > Display, and use the slider to return display settings to 100%.
  • CPU: 1 gigahertz (GHz) 64-bit (x64) processor or better recommended.
  • WebView2, if not automatically installed with Power BI Desktop or uninstalled. Download and run the installer for WebView2.

In addition, after meeting the above requirements, please update your Power BI Desktop version to the latest version.

Download the Power BI Desktop

Then please try to connect to snowflake in Power BI Desktop again and check if it can load the data frequently...

Connect to Snowflake in Power BI Desktop

Use the CData ODBC Driver for Snowflake in Microsoft Power Query

Here is a thread with a similar problem to yours, please check it for the solution. Hopefully it will help you solve the problem too.

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

 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.

Best Regards