Privacy Setting causing failure when report is refreshed when Published.

[JOntie9999]

Hi

I have 2 data sources. 
1. Sharepoint Folder
2. Business Central On-Premise

A test dashboard refreshes successfully when published. 
It also refreshes successfully when a column is added to a table in PBI desktop.
When a column is added with a merge in transform it refreshes successfully in desktop.

However, it fails the refresh when published.

I have set Privacy Setting on both tables to Organisation.

I have tried both "ignore" and "Combine Datat according to each source privacy settings".
I have tried many combinations.

It is successfully connecting in the gateway.

Below is the full error text

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data. Please specify a privacy level for each data source."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Dynamics 365 Business Central (on-premises)\",\"path\":\"http://xxxxxx09:7048/BC180BI/ODatav4/Company/\"},{\"kind\":\"SharePoint\",\"path\":\"https://xxx.sharepoint.com/sites/ProjectLoadingSheets\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: Query2.
Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 038cd73d-79b3-46e7-9
Request ID: 0dbe26fe-9da4-5dbd
Time: 2023-10-04 14:48:48Z

[v-xiaoyan-msft]

Hi  @JOntie9999 ,

Besides the suggestion from Ibendlin,you may aslo try:

1.Verify the gateway version is up to date.
2.Verify the report has a gateway selected1. If there is no gateway selected, the data source might have changed or might be missing.
3.Disable scheduled refresh. Publish from Power BI Desktop to the workspace. Check the report in the workspace. If this contains the latest data, run an ad-hoc request in the service. then check the report again

4.check if the data reverted then you have something in your Power Query (for example parameters) that causes this behavior.
5.Try publishing the report in a different workspace and refreshing it. If it works, you should remove it from the workspace where it was implemented and publish it again.

Hope it helps!

Best regards.
Community Support Team_Caitlyn

[JOntie9999]

Hi Community Support Team_Caitlyn

I tried all of the above and still get the error below. I have now added the column in DAX instead of transform. 

Thank you for your answer.

[JOntie9999]

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data. Please specify a privacy level for each data source."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Dynamics 365 Business Central (on-premises)\",\"path\":\"http://xxxxxx/BC180BI/ODatav4/Company/\"},{\"kind\":\"SharePoint\",\"path\":\"https://xxxxxx.sharepoint.com/sites/ProjectLoadingSheets\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: Query2.
Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID: a8addb5f-6f21-4b1b-943f-2dcb75f62650
Request ID: 59e6cb99-13b6-381b-b0c3-5eb688a5c40b
Time: 2023-10-10 08:32:04Z

[lbendlin]

Set both sources to the same level. Usually Organizational.

[JOntie9999]

Thank you - they are both set to organisational.