Forum Discussion

arusky's avatar
arusky
Frequent Visitor
4 years ago

Power BI Dataflow from Snowflake without Gateway

Hi,   I am currently grabbing the data from Snowflake using advanced editor to query the data in dataflow. It requires the data gateway to be on, and I wonder if we can connect the dataflow to Sno...
Dataflow
Need Help
Tips and Tricks
arusky's avatar
arusky
Frequent Visitor
4 years ago

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

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:

  1. Download and install the gateway on a local computer.
  2. Configure the gateway based on your firewall and other network requirements.
  3. Add a gateway data source.

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.