Forum Discussion

Hugo123's avatar
Hugo123
New Member
1 year ago

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 bu...
Need Help
collinq's avatar
collinq
Icon for Super User rankSuper User
1 year ago

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