PowerBI Service Sync failed using connection type=file via Gateway to an .accdb

[ez__]

I'm trying to schedule a refresh a Semantic Model using connection via Gateway (cluster), using a windows account enabled to write, read, execute actions, to an .accdb file containing tables+forms; privacy level isn't public but 'organizational'; connection type=file;auth metod=windows.

I want to sync data contained into the tables of my Semantic Model.

-PowerBI Desktop: Using 'refresh' button the semantic model refresh is working fine; I can refresh and publish (manyally)
-PowerBI Service: I get DM_GWPipeline_Gateway_MashupDataAccessError 

What do you suggest to solve the problem?

[Anonymous]

Hi @ez__ 

Have you checked and ruled out the following issues?
Troubleshoot Access and XLS import issues in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Jayleny

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

[ez_]

Hi Jayleny thanks for the interesting troubleshooting link. My issue isn't about the initial import data phase from Access DB: the import is successful, I can refresh the data and publish the Semantic Model. The issue is about the onDemand refresh and the sheduling, using PowerBIService.

[ez_]

"Power BI can connect to data by using existing connectors and generic data sources, like ODBC, OData, OLE DB, Web, CSV, XML, and JSON. Developers can also enable new data sources with custom data extensions called custom connectors. Microsoft certifies and distributes some custom connectors as certified connectors." 

Connector extensibility in Power BI - Power BI | Microsoft Learn

have you tried some custom connector to Access .accdb file ?

[ez_]

Hi thanks but is a business requirement....

[lbendlin]

I would suggest moving away from Access as the data source. Do you have the option to use a real database like SQL Server?

[mohdmohideen200]

The error code indicates that a data access error occurred during a mashup operation within a gateway pipeline, which is part of a larger data management system.