Forum Discussion
Help Needed with “DM_GWPipeline_Gateway_MashupDataAccessError” Access Database in Power BI Service
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!
3 Replies
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
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
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.
