Forum Discussion
SnowFlake refresh problem
Snowflake suggested using the latest ODBC driver with a DSN to fix the issue temporarily
We are in the middle of trying this solution. It isn't working out well. It requires us to change much of the development we have between our ETL product and Snowflake. The performance is horible. It then requires a gateway to refresh in the Power BI Service (recently a gateway was not requried by Snowflake). Also, this will all have to be reverted once the regular Snowflake driver works. This may be appropriate if you have a very small amount of tables, but otherwise it isn't great.
It looks like they fixed this issue. I can refresh dataset on both Power BI desktop and cloud now.
It is working for me now also.
What a PITA to fix all swap all my connections. I hope Microsoft stops breaking this every year. Sign those SSL certs for 20 years in the future or set them to not expire.
Confirmed that the issue is fixed with the latest release of PowerBI desktop which was pushed out yesterday. Also the service now works for refreshes to Snowflake without the gateway as it did before this issue started.
- Can you give me the details on how to configure the data source in the gateway please. I named my local DSN as snowflake and it works for the local desktop reports, but putting DSN= snowflake in the gateway's connection string isn't working
