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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
emarshall
Advocate I
Advocate I

Dataflow Merging & Privacy

My understanding is that merging a query pointing at one data source (eg a SQL database) and another data source (eg a SharePoint folder) is risky (if options are changed to "Always ignore privacy level settings") as there is the potential for information to be leaked between sources. Chris Webb has documented this in his series below:

 

https://blog.crossjoin.co.uk/2017/05/24/data-privacy-settings-in-power-bipower-query-part-1-performa...

 

I am wondering whether there is still a potential for unwanted data transfer when dataflows are involved (eg I use a dataflow to connect to a SQL database, then I query the associated entity of that dataflow using Power BI Desktop, then I create another query in Desktop to files in SharePoint, then I merge the two queries in Power BI Desktop together).

 

Are dataflows an effective way of getting around this unwanted data transfer issue?

 

 

 

 

1 ACCEPTED SOLUTION
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

yes, if you create each entity in separate dataflow it should be fine, casue dataflows data isnt keep or manage on the source or the power bi service, its located on the azure datalake V2, and them you pulling information from that datalake via the dataflows, so if you have 2 dataflow indepent one from the other and quer the dataflows together on a new model it should be fine. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




View solution in original post

1 REPLY 1
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

yes, if you create each entity in separate dataflow it should be fine, casue dataflows data isnt keep or manage on the source or the power bi service, its located on the azure datalake V2, and them you pulling information from that datalake via the dataflows, so if you have 2 dataflow indepent one from the other and quer the dataflows together on a new model it should be fine. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors