Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
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.
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.
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:
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!!
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
97 | |
71 | |
67 |