Power BI Reports Connected to Snowflake - Refresh Error

[JaimeMabini]

Hello,

I created a report that is connected to Snowflake as the datasource. When refreshing the data from PBI desktop, I dont encounter any issue and it's refreshing smoothly. 

ODBC is configured and running smoothly.

Gateway with snowflake data source type has "Connection Successful" tag.

But everytime I refresh the report I get this error:

Note: Everytime I manually refresh the report, I get the same error but the Table where the error is coming from is changing. for example in this error, the table was " example.table" and when I refreshed this gain, it will get the same error but with a different table.

Thank you!

Hoping that someone can help me with this.

-Jaime

[Anonymous]

Hi All,

Was doing a Snowflake POC and was trying to connect Power BI to Snowflake.

1. Was manage to connect Power BI Desktop to Snowflake (I did not install ODBC driver or any thing to my cometer where Power BI Desktop is installed)
2. I crerated a Report and published that Report to Power BI Services and was not able to refresh the data and was getting an error that Gateway is not configured.
3. I installed On-Premise Gateway and configured it but still Power BI report on Web services was not working. I was using a Snowfalke AdminUser which was diffrrent from Power BI User. 
4. Then I created a user in SnowFlake same as My Comapny User Name and granted the SYSADMIN Permission in Snowflake and then Went to the Manage Gateway on Power BI Services and added new User ID and password and everything worked. 

[Anonymous]

Did you have to install the snowflake odbc driver on the gateway itself?

[JaimeMabini]

Hello,

My ODBC drivers are up to date and configured correctly.

I found the reason and now the refresh is working properly. The link you gave me is helpful to track the issue.

The reason my report is not refreshing properly is because I dont have the latest gateway version. it shows that my gateway is active but the version is outdated. I updated the version of my gateway and now it's working properly. 

Thank you for the help.

[v-xicai · Accepted solution]

Hi @JaimeMabini ,

You also must install the Snowflake ODBC driver on computers that use the Snowflake connector, using the architecture that matches the installation of Power BI Desktop, either 32-bit or 64-bit. Just follow the following link and download the appropriate Snowflake ODBC driver.

You can refer to the document :https://docs.microsoft.com/en-us/power-bi/desktop-connect-snowflake.

You may go through the troubleshooting links to resolve the issue : https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.