Forum Discussion
Power BI Dataflow from Snowflake without Gateway
Hi arusky ,
From this document you can see, Gateway is not required for Snowflake.
If you don’t open the gateway option for this dataset, you should also go to the “Date source credential” to make sure each credential for the data sources is correctly entered.
What’s more, if the "Gateway connection" didn’t mention that you don’t need a gateway. I think you should also check if all the data source of your dataset are in the cloud, and avoid the condition of merging or appending on-premises and cloud data sources, which is explained in this document:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud
Finally, you can also check if the option has been turned on in your gateway setting:
More reference: Connect to Snowflake with Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yanjiang-msft, Thanks for your response.
Yes. All data in dataflow are cloud basis since they are all from Snowflake.
As you see above, gateway option is default on.
I can turn off the individual dataset using Snowflake, but dataflow is grayed and does not allow turning off.
The below option you mention is turned on. Does it mean I need to turn it off? unchecked that option, but it still does not allow me to turn off the gateway at the dataflow gateway connection setting.
Please advise.
Thanks,
David Lee
Hi arusky ,
Sorry for late back. By my test, if there's no need to configure a gateway, in the Gateway connection option, it will show "You don't need a gateway for the dataset" like below. From your snapshot, it differ from this, so I suggest you try to configure a gateway.
Follow the steps:
- Download and install the gateway on a local computer.
- Configure the gateway based on your firewall and other network requirements.
- Add a gateway data source.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm struggling with the exact same issue. Did you find a solution?
