Power BI Gateway Snowflake sources going offline

[powerbi_jenhen]

Hi,

We have three on-premise gateways (DEV, TEST, PROD). We have multiple snowflake sources setup across these, suddenly today we've started seeing these specific sources (databricks sources running on the same oauth 2.0 are fine) going offline forcing a gateway server restart to get these back online, but only for an hour or so. We upgraded our DEV gateway to the latest version (TEST and PROD are on a 3 month older version) but still we see the issue happening? The gateway servers have ample storage on them.

Any help appreciated.

[v-zhangti · Accepted solution]

Hi, @powerbi_jenhen 

The issue was reported internally, if there is any progress, I will update here.

Best Regards,

Community Support Team _Charlotte

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

[powerbi_jenhen · Accepted solution]

Microsoft seem to have fixed this issue. The only work around we could do was configure these gateway sources as cloud sources instead. Glad it's now fixed.

[powerbi_jenhen]

Typical error being received on dataset refreshes containing snowflake sources is:

Access token has expired, resubmit with a new access token

[v-zhangti · Accepted solution]

Hi, @powerbi_jenhen 

The issue was reported internally, if there is any progress, I will update here.

Best Regards,

Community Support Team _Charlotte

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