Forum Discussion
Multiple data sources gateway
Hi bo_afk ,
Based on that message I am wondering if your SQL really is on-prem or if it is Azure? That message states that everything in the dataset is in the cloud. You started out your thread mentioning that you have a single report with two datasources that make up a dataset. Is that the case? Or, is it two reports, one with each data source?
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?
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.