Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
8 months ago
Solved

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?

Need Help

5 Replies

  • rohit1991's avatar
    rohit1991
    Super User
    8 months ago

    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.

  • KarinSzilagyi's avatar
    KarinSzilagyi
    Super User
    8 months ago

    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?