Forum Discussion

bo_afk's avatar
bo_afk
Post Patron
5 years ago

Multiple data sources gateway

Hi, I have a report with multiple data sources that I've published to PBI Service.   Data sources: 1. SQL Server database (on-prem) 2. Snowflake (cloud)   I have a gateway for the SQL Server d...
Need Help
collinq's avatar
collinq
Super User
5 years ago

Hi bo_afk ,

 

I ran across this article which states that the "new" connector (like last week new) does not need a connector.  Announcing enhanced connectivity for Snowflake | Microsoft Power BI Blog | Microsoft Power BI  that same article indicates that you do need a gateway with the older connection (which you appear to NOT need since you have a snowflake only report working fine).

As a rule of thumb, you only need a gateway for local resources.  I have done reports many times this way.  I am wondering if there is soemthing special about the Snowflake connector (and hence why they made a special announcement about it having new functionality.

 

bo_afk's avatar
bo_afk
Post Patron
5 years ago

Hi collinq, thanks for the link!

It's weird that my gateway is supposedly 'Not configured correctly' because I don't have a gateway for Snowflake. It even shows that adding the gateway is optional.