topic Re: Gateway Mashup Data Access Error in Report Server

Gateway Mashup Data Access Error

PHLEX — Tue, 13 Feb 2024 14:04:52 GMT

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!

Re: Gateway Mashup Data Access Error

lbendlin — Tue, 13 Feb 2024 22:58:12 GMT

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.

Re: Gateway Mashup Data Access Error

Anonymous — Mon, 19 Feb 2024 01:39:54 GMT

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.