Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
when i try to refresh pbi report the following error message show up. can somebody help me with this? please!
"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\":\"SharePoint\",\"path\":\"https://xrfusa.sharepoint.com/sites/ProductManagement\"},{\"kind\":\"Odbc\",\"path\":\"dsn=XRF_CAPP\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: Interchange.
Hi @DATASM ,
Based on the error message, there appears to be a data access error related to privacy level or credentials. This is often encountered when merging data from different sources with different privacy levels set in Power BI.
Please check in the data source settings that the data source credentials are all correct, as well as the privacy level for each data source.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tak a closer look at your table 'Interchange'. I bet there is some step in power query causing this.