Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Raaassotto
Helper I
Helper I

Why newlycreated dataflow automatically creates gateway

Please help me on the issue:

Everytime I try to create a dataflow a new gateway is automatically created. It's got created even before I finish the process of dataflow creation. Is it posible to prevent gateway creation?

When I create a dataflow for sharepoint it creates a gateway to sharepoint and brakes the connection of other users of sharepoint datasorces in my organization. 

1 ACCEPTED SOLUTION

Yes. For now you can't change that. It shouldn't duplicate. If it duplicate it is because you are not dealing with the same source or you have type something differente in the configuration.

NOTE: consider that each file or folder is a source. You will need that. It's not a mess if you need it.

Regards,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

6 REPLIES 6
ibarrau
Super User
Super User

Well, it's helpfull if you standarize the source input because you will have to configure it in order to refresh the dataflow later. So, the behave will be helpfull at the end unless you are just testing stuff.

It is ok to have a source definition in the gateway for onpremise data.

Each file is a source, each folder is a source, each DB is a source. Just to be clear when dataflow will create a new source in gateway. You will need those. So it's not so bad.

Hope it make sense for you


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Thank  you for your reply. It's helpful. But I don't see any solution to prevent the mess in the Gateway configuration with a growing list of sources. They are even duplicating on every attempt to create a new dataflow. 

Yes. For now you can't change that. It shouldn't duplicate. If it duplicate it is because you are not dealing with the same source or you have type something differente in the configuration.

NOTE: consider that each file or folder is a source. You will need that. It's not a mess if you need it.

Regards,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

You are right. It wasn't actually duplicat. There were differences. Thank you for your help!

ibarrau
Super User
Super User

Hi. Are you sure it's a new Gateway? I think you might be confusing with a new Data Source in the picked up gateway from a dataflow configuration.
DataFlow need gateway for some sources and it will auto create the configuration for that if its the FIRST time you are using the source. You can avoid that adding yourself the sources to the gateway and use the same text for each box when connecting that data with dataflows.

Hope it make sense.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

I see those sources in this Gateway connectin lists. Everytime I create the dataflow to a new source, this source adds to this list. Even local foulders are added.

 

Raaassotto_1-1611667061134.png

 

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors