user can't refresh the report in the workspace, latest data can't be updated in the online file

[it_kwwk]

Hi there,

I have a report that retrieves data from 3 different SAP databases and 2 spreadsheets from SharePoint.

I've already set up 3 gateways for SAP, and they work well in this report and others.

Additionally, I've set up 1 cloud connection for the SharePoint root URL.

All four gateways are online status.

In my report, I append data from these 4 sources into one table. I can refresh and retrieve the latest data in my local file and successfully publish it to the workspace. However, the issue is that other users cannot refresh and retrieve data in the online file.

I checked the model, and the detailed error message is below. Does anyone know why this is happening and how to fix it? Thanks!

[anilelmastasi]

Hello @it_kwwk ,

1.Adjust Privacy Levels in Power BI Desktop
Open Power BI Desktop.
Go to File → Options and Settings → Options.
Under Global → Privacy, check "Ignore Privacy Levels" (this allows merging different data sources).
Click OK, then restart Power BI.

2. Set Compatible Privacy Levels for Each Data Source
Go to Power Query (Transform Data).
Click on "Data source settings".
Select each data source (SQL & SharePoint).
Click "Edit Permissions".
Change Privacy Level to "Organizational" for all sources (instead of "Private" or "Public").
Click OK, then refresh your data.

3. Check Gateway Mapping in Power BI Service
Since you're using on-premises gateways for SAP (SQL) and cloud credentials for SharePoint, make sure:

All SQL sources are mapped to the correct on-prem gateway.
SharePoint uses cloud credentials (OAuth2).
Ensure both data sources are correctly configured under the same gateway, if applicable.

4. Republish the Report & Set Permissions in Power BI Service
After fixing the settings, republish the PBIX file.
Go to Power BI Service → Dataset Settings.
Under Data Source Credentials, re-enter credentials if needed.
Manually trigger a refresh to verify that it works.

If that helps, please accept as solution, thank you.