Power Bi refresh

Hi Naaib,

Thank you for reaching out to the Microsoft fabric community forum. Additionally, thank you to christinepayton, for his input regarding this issue. I have identified several alternative workarounds that may assist in resolving the thread.

To resolve this issue, start by opening your report in Power BI Desktop and checking the Power Query Editor for any steps that combine Oracle and SharePoint data using operations like Merge or Append. These operations trigger Power BI's privacy level enforcement, which must be explicitly configured for refreshes to work in the Power BI Service.

Next, go to File > Options and Settings > Options > Privacy and ensure that “Always combine data according to your Privacy Level settings” is enabled. Then open Data Source Settings, select each data source, click Edit Permissions, and set both Oracle and SharePoint to Organizational (or Private, if appropriate). Re-authenticate if required.

After saving these settings, re-publish the report to Power BI Service. In the Service, go to your workspace > dataset > settings. Under Gateway Connection, verify that the On-premises Data Gateway is online and that both data sources are correctly configured under the same gateway cluster.

Then, in the Data source credentials section, enter valid credentials and set the privacy level to match the one used in Desktop (Organizational is recommended). Save the changes and perform a manual refresh in the Service to confirm the fix. If successful, you can proceed to set up a scheduled refresh.

Kinly refers to the below following documentation links for better understanding:
Privacy levels in Power Query - Power Query | Microsoft Learn
Configure scheduled refresh - Power BI | Microsoft Learn
Troubleshoot gateways - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you again for reaching out on the Microsoft Community Forum.

Hi Naaib 

You're encountering the following Power BI error when trying to refresh a dataset in the service:


This is a Privacy Level issue between multiple data sources (Oracle and SharePoint). Power BI enforces privacy boundaries during mashup operations (when combining data from different sources). It behaves differently in Power BI Desktop versus Power BI Service.

Configure Privacy Levels Correctly in Data Gateway
Since your data comes from both Oracle and SharePoint Online, and you're likely using a Gateway (for Oracle), follow these steps:

1. Go to Power BI Service > Settings > Datasets

• Find your dataset

• Click on “Settings”

• Scroll to Gateway connection and Data source credentials

2. Edit credentials for each data source

• Ensure both Oracle and SharePoint data sources are added to the same Gateway cluster

• Set privacy levels:

• Choose Organizational for both, or Public if the data isn’t sensitive and it’s safe to combine.

3. Save and retry the refresh

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!