Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
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
You could try turning off the data privacy setting check in the report settings?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
38 | |
37 | |
32 | |
25 | |
24 |
User | Count |
---|---|
38 | |
29 | |
23 | |
21 | |
17 |