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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
IamTDR
Responsive Resident
Responsive Resident

DataFlows - Gateway Question

I am starting to final creating a Dataflow to connect to several reports instead of the various reports doing all the same transformations over and over again.

I was able to create my Dataflow in Power BI Service and use the DataFlow in my reports.

My concern is when I look at the reports now using the DataFlow in Power BI Service.  In reviewing the Report's Setting, I see that the Gateway is set to 'Cloud Connections - Personal Cloud Connection'.  Wasn't sure what this meant to be honest.  My concern is that for these various reports to refresh, they would need my personal computer to always be on.

So my question, is this correct in that my reports would not refresh unless this personal computer is online at the refresh time?  Is this the proper way to use DataFlows?  My IT Department set up the Gateways so I'm a bit behind on understanding them.  Perhaps I will need to bug my IT Department to set up a Dataflow Gateway to refresh??
Thanks

2 ACCEPTED SOLUTIONS
collinq
Super User
Super User

That said,  I think that the default these days is for the cloud connection to automatically map to the data source.  When I have seen this I just turn it off - I makes sure the "map to" in the cloud connection is set to "none" or "blank" so that it doesn't use that one for sure.

 

I do this because you are right that there are limitations on how those connections work.

 

 

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

lbendlin
Super User
Super User

You can ignore these "Personal Cloud Connection" items. They serve no purpose at the moment. 

 

Dataflows do not require a gateway when they are being consumed.   They may require a gateway when being refreshed.  That gateway should be an On-Premise (Standard/Enterprise) gateway. A VM in your on-prem network, not your personal PC.

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

You can ignore these "Personal Cloud Connection" items. They serve no purpose at the moment. 

 

Dataflows do not require a gateway when they are being consumed.   They may require a gateway when being refreshed.  That gateway should be an On-Premise (Standard/Enterprise) gateway. A VM in your on-prem network, not your personal PC.

collinq
Super User
Super User

That said,  I think that the default these days is for the cloud connection to automatically map to the data source.  When I have seen this I just turn it off - I makes sure the "map to" in the cloud connection is set to "none" or "blank" so that it doesn't use that one for sure.

 

I do this because you are right that there are limitations on how those connections work.

 

 

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.