On-premises data gateway is not available on the dropdown list of connection setting of Dataflow

(0) Share

Report

Posted on by CU10100241-0

I am trying to pull data from Azure Table storage to a dataverse table by using Data Flow. But Wen I try to setup connector I don't see the On-premises data gateway. But I see the Gateway available as part of the list of gate ways in the Power Platform Environment.

Has anyone faced similar issues?

Categories:

General Comment

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

stampcoin 4,426 Super User 2025 Season 2 on at

Like (1)

Report

On-premises data gateway is not available on the dropdown list of connection setting of Dataflow

@CU10100241-0 Hi,

Did you create the gateway first ?

I have the gateway from the dropdown after I created my gateway.

Below is the one I created.

Enjoy Power Platform and have a great day 🚀 | My LinkedIn

If the answer helps, please consider 👍, Thanks.

Was this reply helpful? Yes No
CU10100241-0 2 on at

Like (0)

Report

On-premises data gateway is not available on the dropdown list of connection setting of Dataflow

Thanks @stampcoin,

Our Power Platform Admin has created for me. I will ask him to create the Data Flow for me and check if it works.

I have a storage account where I have table. I have a data flow which fetch data from this Storage table to populate a dataverse table. It works if public is access enabled for the storage account.

But recently I had to restrict access to selected subnets and trusted MS services. After that the data flow is not working. I have tried adding Power Platform's Azure IP addresses/Service Tags for the region but no luck.

VNet data gateway can be option but not sure how it is going to impact our existing power apps/power BI etc.

Any suggestions?

Was this reply helpful? Yes No
Michael E. Gernaey 51,278 Super User 2025 Season 2 on at

Like (0)

Report

On-premises data gateway is not available on the dropdown list of connection setting of Dataflow

NI @CU10100241-0

To add to @stampcoin 's thoughts, I want to check if you are using a VNET or are these Managed Instances?

Was this reply helpful? Yes No
RC-13100041-0 2 on at

Like (0)

Report

On-premises data gateway is not available on the dropdown list of connection setting of Dataflow

Thanks guys for replying to my questions. I could not setup Gateway to connect to Storage table but found another way to connect. I have added the IP address of "PowerQueryOnline" on the access list of the storage account.

Previously I was using Power Platform Infra IP address and not able to connect and that is the reason I was trying gateways to connect.

1 people found this reply helpful.

Was this reply helpful? Yes No
stampcoin 4,426 Super User 2025 Season 2 on at

Like (0)

Report

On-premises data gateway is not available on the dropdown list of connection setting of Dataflow

@CU10100241-0 Hi,

Thanks for sharing the info.

If that works well, please mark your reply as the answer.😉

Was this reply helpful? Yes No