Odd Mashup Error - Refreshes Failing

[norcalchrissr]

We have refreshes failing on multiple data sources despite the gateway being online and credentials cross checking. Table fields have not changed, just on a republished version after credentialling was changed, but all updated. Any thoughts:

• 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"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"tas2;kern\"},{\"kind\":\"PowerBI\",\"path\":\"PowerBI\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: ORDERS.
• Cluster URIWABI-US-WEST2-redirect.analysis.windows.net
• Activity ID00000000-0000-0000-0000-000000000000
• Request IDd81a501f-b6dc-41fb-a1d1-becdc72702ee
• Time2022-08-22 17:11:35Z

[grmesser]

Set the privacy level to what?  There are 4 settings.

[wikkleyn · Accepted solution]

Hi @norcalchrissr , One of our users had the same issue recently. Resolved it by setting the Privacy Level for all the data sources.

Data soure Settings > Edit Permissions > Set the Privacy Level

[norcalchrissr]

Thank you will try this now!