Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Privacy Levels PowerQuery

Hello everybody, 


I have a problem with privacy levels in PowerQuery. If I'm using mit Queris in the office and update the queries everythink is working fine, if i'm going to use the Querys in homeoffice via vpn i have to set the privacy levels again. Doing so in homeoffice everything is working fine again. Back in office I have to set privacy levels again. 


Sometimes I'm getting a notice message to set privacy levels again and can choose if it is okay. Sometimes PowerQuery just updates the queries without a notice message. It seems that the query is updated, but in truth nothing is happend. I just can see a warning triangle if I'm going to fade in the connections on the right side. 


Is there a possibility that everytime I get a notice message for setting privacy levels? 

To circumvent this issue I also thougt about using two different queries. On in company and one in homeoffice with vpn, so that I always have the same privacy leves and the same network. Do you think this will work? 

Community Support
Community Support

Hi @Carl1985 ,


Is that your problem solved? 

If so, please mark the reply as the solution. More people will benefit.

If not, please provide me with more details.


Best Regards,

Stephen Tao

Community Support
Community Support

Hi @Carl1985 ,


The privacy level is also a guarantee of the security of the data source, and it should be carefully considered.

You can modifying the privacy level setting and choosing the third one(Always ignore...) for global.



If you just want modify the current file, go to CURRENT FILE-Privcay Levels.



Set privacy levels (Power Query) - Microsoft Support

Understand Power BI Desktop privacy levels - Power BI | Microsoft Learn

Also here's a similar post, please kindly refer to

Solved: Problem with privacy levels when using PowerQuery ... - Microsoft Power BI Community





Best Regards,

Stephen Tao


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

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors