snowflake
3 TopicsHelp with Power BI scheduled refresh failure - Snowflake connecttion
We've configured a Gateway with our Azure private link that connects to Snowflake. This is not on-premise. The Gateway directly connects to Snowflake via the private link. We are getting intermittent errors. That is, sometimes the data refreshes and other times we get an error. Can someone help us figure out what causes this error. We thought that this might have something to do with the Snowflake warehouse not being awake?Solved1.6KViews0likes1CommentMultiple Snowflake Database Connections across Workspaces
I am only able to have 1 snowflake connection across all reports and all workspaces. Does anyone know how to have one workspace use a snowflake user different than another workspace? Scenario Using PowerBi desktop, I have created a Snowflake data source with database user X. I published the report X to workspace X Using PowerBi desktop, I have created a Snowflake data source with database user Y. I published the report Y to workspace Y Result When I run the report in workspace X, it uses user Y When I run the report in workspace Y, it uses user Y Expected Result When I run the report in workspace X, it uses user X When I run the report in workspace Y, it uses user YSolved778Views0likes1Comment