Help 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?
Connect to multiple tables on the same SQL server using data gateway
Apologies if this has been asked before, I am trying to connect to multiple tables on the same SQL server. My report contains two queries, both referencing two different tables on the same server. THese run fine both within SQL and in the report. I'm trying to set up the report for a scheduled refresh using the data gateway, however I can't get it to connect. This worked fine when I was just referencing the one table but it won't connect to the second table. I've tried adding it in Manage Gateways with no luck. What am I doing wrong? Thank you.
