Forum Discussion

bo_afk's avatar
bo_afk
Icon for Post Patron rankPost 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
bo_afk's avatar
bo_afk
Icon for Post Patron rankPost Patron
5 years ago

Hi collinq, sorry I should've been clearer. That's the message I get from a different report which only has Snowflake as my data source. It was just to show that I didn't need a gateway for Snowflake.

But when I try to publish a report with two data sources (SQL and Snowflake), apparently a gateway is needed for Snowflake?

collinq's avatar
collinq
Icon for Super User rankSuper 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
    Icon for Post Patron rankPost 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.