Mashup error

[kostask]

Hi guys!

Last days my IT department updated the gateway to the latest version.

95% of the reports run smoothly, but in 2 i get the same message while trying to connect to the base. These 2 repoerts are connected to  sharepoint data.

I' ve read many posts reffering to mashup errors and tried everything with privacy levels. I configured the dataset just the same to other that work properly but no good news.

Appreciate your help!

Kostas

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\":\"SQL\",\"path\":\"<ip>10.4.5.205</ip>;sapsta\"},{\"kind\":\"Web\",\"path\":\"https://.............//OrdersOnline.xlsx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: Production.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: 7a8f7661-d1e5-4bb2-9fb9-f5c288d5294e
Request ID: 998375af-aeb7-0b29-5a61-bea9dc4a0f31
Time: 2023-09-15 11:20:36Z

[sergej_og]

Hey @kostask ,

one thing I learned about sharepoint issues is go to your dataset settings (where you can see gateway etc.) and provide your login information one more time. This approach helped me a lot of times with this kind of issue.

maybe it works for you also

[christinepayton]

You could try turning off the data privacy setting check in the report settings?