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

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

Exceed Learning

Exceed Learning

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
@Larimuss 3 ай бұрын
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
@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
@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
@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
@duyanhao9438 2 жыл бұрын
@@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.
How to access global environment objects in Power Query
2:51
Exceed Learning
Рет қаралды 1 М.
Power Query - Understanding each and underscore (_)
12:41
BA Sensei
Рет қаралды 4,8 М.
Зачем он туда залез?
00:25
Vlad Samokatchik
Рет қаралды 3,3 МЛН
Spot The Fake Animal For $10,000
00:40
MrBeast
Рет қаралды 164 МЛН
Now THIS is entertainment! 🤣
00:59
America's Got Talent
Рет қаралды 40 МЛН
How to fix the Formula Firewall in Power Query | Excel Off The Grid
11:26
Excel Off The Grid
Рет қаралды 6 М.
Query folding in Power Query
20:46
SQLBits
Рет қаралды 2,1 М.
List.Generate() Function and Looping in PowerQuery
23:56
Exceed Learning
Рет қаралды 24 М.
Why and how to use data protection in Power BI
8:11
Guy in a Cube
Рет қаралды 30 М.
Convert Multiple Column Groups to Rows in Power Query
17:18
Power Bi / Power Query Privacy Levels explained
11:23
Curbal
Рет қаралды 10 М.