Forum Discussion
Gateway Mashup Data Access Error
Hi,
I am trying to refresh my data that is connected to a microsoft access database through a gateway. When I click refresh, I receive the error message below:
{"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":"Bluesheet be.accdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: tblErrorCodes.
Any help would be greatly appreciated!
2 Replies
Crazy as it sounds the gateway must be able to WRITE to the access db location.
Best to move your data to a more suitable storage solution. That way you can avoid having to install legacy drivers on the gateway cluster members.
Hi PHLEX ,
Try using a personal mode gateway
On-premises data gateway - Power BI | Microsoft Learn
- To edit the contents of the file, navigate to \\server\folder\file.accdb
- To allow PowerBI to use the file and obtain data, navigate to http://server/folder/file.accdb
You can refer to this thread:
Solved: On Premise Gateway - Error connecting to Access Da... - Microsoft Fabric Community
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
