Data privacy (Privacy levels) in Power Query/Power BI

Рет қаралды 7,480

3 жыл бұрын

In this short video, we cover the most important aspects of data privacy in Power Query/PowerBI. In Power Query, privacy levels specify an isolation level that defines the degree that one data source will be isolated from other data sources. You can find more details with an example in the video.
This video is part of our Power Query fundamentals course, which you can find at the following link: exceed.hr/en/academy/powerque...
#powerquery #powerbi #etltools #data #dataanalysis

Пікірлер: 5

@Larimuss 2 ай бұрын

Thanks. Had this popup for a user inexcel. I assume it must also have 2x data sources in pivot tables or something. Since both where internal I just told them to set public

@jaysanghvi4332 3 жыл бұрын

Hi, thank you very much for this video. It was very informative. I just had a few questions: 1. If I have two local excel files on my computer, and I merge them - is there any risk of data leaking? 2. If I wanted to merge data from an online source with private data for analysis, would it be safe if I first imported the data from online, saved in on my computer, and then merged with the private data? Thanks

@ExceedLearning 3 жыл бұрын

Hi Jay! Thanks for asking. below answers: 1. if both sources are on your computer, then no. 2.The approach of saving it locally and then merging is definitely safer than connecting directly to an online source. if connecting to an online source, data leaking can occur in case that source supports query folding and you set your inhouse source to a privacy type different than private. you can also connect directly to an online source with a private privacy setting, just be sure not to hit formula firewall. more about it here: www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

@Wzxxx 2 жыл бұрын

I have 2 data sources on my local drive (all are xlsx files). After i merge them in query steps and change the source (other folder) i am getting the error during refresh. How to handle this without changing privacy setting to ignore. I did change the both files to public but it doesn’t work. I am really frustrated. Just merging data which is the main intention..

@duyanhao9438 Жыл бұрын

@@Wzxxx why did you change the source (other folder) after you merged them in query steps. I dont understand what you mean in your 2nd sentence.