Forum Discussion
Data source error - DM_GWPipeline_Gateway_MashupDataAccessError
We are trying to refreshing this report through Gateway connected to MS Access, and got the below error message. Does anyone encounter similar issue and resolved it? Please advise.
--------
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":"Unspecified error"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"Inv_Turn.accdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: qry_Store_TurnGoal.Cluster URI:WABI-US-EAST2-redirect.analysis.windows.netActivity ID:d017dcdd-5cd3-449e-99d6-66b6a2a0832fRequest ID:4bb94c8f-ea31-b860-6659-455ce56b0585Time:2020-07-10 19:01:34Z
Thanks,
Hi Anonymous ,
Try using a personal mode gateway
Or refer to this thread:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
Access uses .ldb files for locking. Does the user in the gateway connection have write permissions?
Hi Anonymous ,
Try using a personal mode gateway
Or refer to this thread:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
My gateway is online and I am able to refresh on Power BI desktop.
My data sources are MS exchange and SQL Server. Scheduled refresh and on demand refresh fails with this 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":"[Unable to combine data] Section1/exchange_connect/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Exchange\",\"path\":\"[email protected]\"},{\"kind\":\"SQL\",\"path\":\"server.database\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacyError"}}],"exceptionCulprit":1}}} Table: exchange_connect.
Any help would be greatly appreciated.
I am facing same error...
My model has XLSX and SQL queries merged in 1 table. This merge is causing the problem. If i refresh tables separately , it works fine.
