Privacy levels for multiple sources

[stribor45]

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?

[KarinSzilagyi]

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]

[KarinSzilagyi · Accepted solution]

@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. 

[stribor45]

When I click on Data source settings I see three sources

1. Dataflow - credentials "Organizational" and privacy level "Organizational"
2. Web - credentials "Basic" and porivacy level "Organizational"
3. Sharepoint - credentials "Organizational" and privacy level "Organizational"

Refresh in Desktip works fine no problem. When I publish to service it starts refrshing in service right away and after 5 minutes gives me this error

Information is needed in order to combine data. Please specify a privacy level for each data source.;Information about a data source is required.. The exception was raised by the IDbCommand interface.

Options and settings for

global -> combine data according to each file privacy level setting

current file -> combine data according to your privacy level settings for each source

[rohit1991]

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.