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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
lherbert501
Post Patron
Post Patron

PBIT Template Privacy Settings

Hi there,

 

Does anybody know how template files (PBIT) work when it comes to privacy?

 

I have changed the settings to ignore like in the image below, but I still get the privacy level pop up and then have to constantly refresh to get it to load along with the "Query references other queries or steps, so it may not not directly access a data source" error.

 

lherbert501_0-1719821664268.png

 

 

 

4 REPLIES 4
v-tangjie-msft
Community Support
Community Support

Hi @lherbert501 ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

 

Best Regards,

Neeko Tang

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

v-tangjie-msft
Community Support
Community Support

Hi @lherbert501 ,

 

This can have several problems behind, check the documentation below with information about possible errors and examples:

Dealing with errors - Power Query | Microsoft Docs

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Docs

Solved: references other queries or steps, so it may not d... - Microsoft Fabric Community

In addition to this, can you try changing the privacy level of all your data sources to "Organizational" or "Public".

 

 

Best Regards,

Neeko Tang

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

rajendraongole1
Super User
Super User

Hi @lherbert501 - Managing privacy levels in Power BI, especially when working with template files, requires careful configuration of data source settings and understanding how queries reference each other.

By setting privacy levels explicitly, enabling fast combine, and using the latest version of Power BI,

you can minimize privacy-related issues and ensure a smooth experience with template files.

Changing Privacy Settings:

 

  • Go to File -> Options and settings -> Options -> Privacy.
  • Select Privacy Level settings for this file.
  • Choose Ignore the Privacy Levels and potentially improve performance to bypass privacy levels, but be cautious as this might expose sensitive data.

 

  • Go to File -> Options and settings -> Data source settings.
  • Set the appropriate privacy level for each data source (Public, Organizational, or Private).

ref:

Re: Security with templates/pbit files - Microsoft Fabric Community

 

 

Hope it helps

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

 

 

 





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

Proud to be a Super User!





Hi @rajendraongole1 ,

 

Many thanks for the reply. I think this is the problem I seem to be having though, as I have done the usual change from combine to ignore in the options.

 

I then have set them all to public the data sources in the query editor.

 

I export this to PBIT and it brings up the option to ignore both sources which I check, and then gives me all of the errors which I have to refresh.

 

Thanks

 

Liam

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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