Help Needed with “DM_GWPipeline_Gateway_MashupDataAccessError” Access Database in Power BI Service

[Hugo123]

Hi everyone,

I’m facing an error when refreshing Power BI reports on Power BI Service connected to an Access database (.mdb).

Everything works fine in Power BI Desktop, I can refresh and publish but it fails on Power BI Service.
I’ve confirmed:

•Data is clean, types are consistent.

•Gateway is configured with an account having Access installed.

The error details are as follows:

{"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":"Erreur non spécifiée"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"Gard.mdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: SITCLI.

URI du cluster: WABI-FRANCE-CENTRAL-A-PRIMARY-redirect.analysis.windows.net

ID d'activité: 74dd15e1-b2e1-46c3-bb65-0aa0b0d172f2

ID de demande: fe7e9115-7185-65b1-b7f1-dee1115965a5

Heure: 2024-10-25 12:40:35Z

Has anyone encountered this or have any ideas on fixing it? Could it be an Access-specific compatibility issue?

Thanks for any help!

[Anonymous]

Thank you SaiTejaTalasila  and collinq 

Hi, @Hugo123 

I think you can refer to the solution of the following case, in which the owner encountered the same error as yours, also using Access database.

Solved: DataFormat.Error when refreshing Access database i... - Microsoft Fabric Community

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SaiTejaTalasila]

Hi @Hugo123 ,

It looks there are errors in your data.

{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}}. Turn on column profiler/column quality and check all your applied steps one by one.

Thanks,

Sai Teja 

[collinq]

Hi @Hugo123 ,

This article has a number of options: Troubleshoot Access and XLS import issues in Power BI Desktop - Power BI | Microsoft Learn

Also, you stated it but have you absolutely confirmed that there are no odd data bits in the SITCLI table?

Are you using an ODBC connector to get to Access?  If so, the exact same version needs to be installed (and named the same preferrably) on the Gateway server.

Or, you can review this article with some tips:

Power Query Access database connector - Power Query | Microsoft Learn