Forum Discussion
Privacy levels for multiple sources
I am trying to troubleshot privacy levels for different data sources that I have in my report. I set them up but when I publish it in service the refresh fails and I cant seem to isolate it to particular source that has issue. When I refresh my local PBIX refresh works but fails in service. Is there something I can do at report to isolate it so when I publish it i know it will work.
Every time I upload to service refresh starts and it takes like 5 minutes beofr eit tells me it fails. Any suggestions hiow to troubleshot this locally?
stribor45 Do you actually have sources that require different privacy levels in your report? E.g. Data personal data that would require "Private" level vs "Organizational"?
https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/desktop-privacy-levels
If you don't have any actually sensitive data I would recommend to change all your sources to Organizational, then try if the refresh still fails.
5 Replies
Hii stribor45
Privacy-level issues only appear in the Power BI Service, not Desktop, because the Service applies strict isolation rules when combining multiple sources. Even if the PBIX refreshes locally, the Service may block the refresh if sources with different privacy levels (e.g., Organizational + Public) are being merged. To troubleshoot locally, go to File >> Options >> Global >> Privacy >> Always ignore privacy settings and refresh if it works only with this option ON, it means a source-combination privacy conflict will fail in the Service. The solution is to either:
(1) set all data sources to Organizational, or
(2) avoid merging sources with different privacy levels. Once all sources use the same level, the refresh will work in the Service.
Hi stribor45, which setting are you currently using for the Privacy Level-combinations in your file and which privacy levels do you use within your sources?
stribor45 Do you actually have sources that require different privacy levels in your report? E.g. Data personal data that would require "Private" level vs "Organizational"?
https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/desktop-privacy-levels
If you don't have any actually sensitive data I would recommend to change all your sources to Organizational, then try if the refresh still fails.
