Gateway Mashup Data Access Error

[PHLEX]

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!

[Anonymous]

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.

[lbendlin]

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.