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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
KBIReports
Frequent Visitor

Privacy Level Desktop and Service

Hello, 

 

I am receiving the following error: 

Data source 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.

 

The report hits several end points in the same Rest API. I recently updated the call due to a domain name change. After that time, I am no longer able to automatically refresh the report in service but it is working fine in the desktop. Data Source Credentials in the service Authentication is set to Anonymous and Privacy Level set to None with skip test connection checked. The Data Source setting credentials in the desktop is set to Anonymous and Privacy Level None. Finally, in the desktop File -> Options -> Privacy Always Ignore Privacy Levels is checked. I have read many posts with conflicting solutions. Any help would be much appreciated.

DataSourceFileSettings.jpg

ServiceDataSourceCredentials.jpg

 

2 ACCEPTED SOLUTIONS
pallavi_r
Super User
Super User

Hi @KBIReports ,

 

The setting - 'ignore Privacy level' might not always work on Power BI service. Some new queries might be causing issues. Please check the below snapshot from link - https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels

pallavi_r_0-1736966134922.png

You can also upvote this idea here where community members have mentioned this issue similar to yours - https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=274ef1e0-17dd-40bb-b5fe-19a701131136

So recommended:

1. Clear your permissions before starting

pallavi_r_1-1736967581872.png

2.Select Current File -> Privacy -> Combine Data according to your privacy levels for each source.

3. Set privacy level as per the data sources and keep it consistent across each data sources

4. First try in desktop by setting the privacy level of datasources to organizational or public as applicable. It has to be consistent across all data sources. Try refreshing.

5. Ensure you maintain the same privacy level setting at Power BI Service -> Data Source Credentials- > Privacy Level Setting, Manage connections and Gateways

 

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi

View solution in original post

v-ssriganesh
Community Support
Community Support

Hi @KBIReports,
Thanks for posting your query in Microsoft fabric community forum.

Based on the error message you provided, I identified that the issue stems from the privacy level settings of the data source configuration. To troubleshoot this, please follow the steps below to check for any inconsistencies in the "Privacy setting" configurations:

1. First, open the corresponding PBI desktop local file. Then, navigate to "Option and Settings-Options" to enable this option:

vssriganesh_0-1737367820025.png

2. Navigate to "Data Source Settings" and ensure that the "Privacy setting" of all connected data sources are consistent:

vssriganesh_1-1737367847832.png

3. Once consistency is confirmed, please proceed with a desktop data refresh to ensure successful completion.

4. Once the refresh is successful, please republish and attempt to reconfigure the data source definition for the related dataset. This will ensure that the "Privacy level" configured on the Service matches that of the Desktop.

vssriganesh_2-1737367988019.pngvssriganesh_3-1737368001982.png

If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Thank you.

View solution in original post

5 REPLIES 5
v-ssriganesh
Community Support
Community Support

Hi @KBIReports,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

 

v-ssriganesh
Community Support
Community Support

Hi @KBIReports,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

v-ssriganesh
Community Support
Community Support

Hi @KBIReports,
Thanks for posting your query in Microsoft fabric community forum.

Based on the error message you provided, I identified that the issue stems from the privacy level settings of the data source configuration. To troubleshoot this, please follow the steps below to check for any inconsistencies in the "Privacy setting" configurations:

1. First, open the corresponding PBI desktop local file. Then, navigate to "Option and Settings-Options" to enable this option:

vssriganesh_0-1737367820025.png

2. Navigate to "Data Source Settings" and ensure that the "Privacy setting" of all connected data sources are consistent:

vssriganesh_1-1737367847832.png

3. Once consistency is confirmed, please proceed with a desktop data refresh to ensure successful completion.

4. Once the refresh is successful, please republish and attempt to reconfigure the data source definition for the related dataset. This will ensure that the "Privacy level" configured on the Service matches that of the Desktop.

vssriganesh_2-1737367988019.pngvssriganesh_3-1737368001982.png

If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Thank you.

Hi @KBIReports,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

pallavi_r
Super User
Super User

Hi @KBIReports ,

 

The setting - 'ignore Privacy level' might not always work on Power BI service. Some new queries might be causing issues. Please check the below snapshot from link - https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels

pallavi_r_0-1736966134922.png

You can also upvote this idea here where community members have mentioned this issue similar to yours - https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=274ef1e0-17dd-40bb-b5fe-19a701131136

So recommended:

1. Clear your permissions before starting

pallavi_r_1-1736967581872.png

2.Select Current File -> Privacy -> Combine Data according to your privacy levels for each source.

3. Set privacy level as per the data sources and keep it consistent across each data sources

4. First try in desktop by setting the privacy level of datasources to organizational or public as applicable. It has to be consistent across all data sources. Try refreshing.

5. Ensure you maintain the same privacy level setting at Power BI Service -> Data Source Credentials- > Privacy Level Setting, Manage connections and Gateways

 

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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