Power BI Service unable to refresh Access Database with linked connection

[FerdinandP]

Hi Guys

I have a report using as its datasource an Access Database with a linked table. The linked table refreshes from a csv file.

Refreshing this report from Power BI desktop works perfectly. When we try to refresh the the datasource from the Power BI Service however it fails and we get this error:

Underlying error code: -2147467259
Underlying error message: We're sorry, an error occurred during evaluation.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Cluster URI: WABI-AUSTRALIA-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 7d8e94d1-7eeb-454c-b7cd-40f64aea4736
Request ID: 13172f13-6e53-3b4a-74fe-65f0dbc8488d
Time: 2022-02-15 06:29:24Z

We have ensured all the network paths are exactly the same in both Desktop and in the Enterprise Gateway and installed the latest versions of MS Access and the Access Databse Engine on both my PC and on the Gateway.

When testing the exact same report but using an Access Database that does not have linked tables, the refesh works.

[Anonymous]

Hi @FerdinandP ,

Is there any detailed error message except error code?

You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues.

If it is not there, then you could post it.

Best Regards,

Jay

[FerdinandP]

Hi Jay

The most detail I get is this:

Underlying error code: -2147467259
Underlying error message: We're sorry, an error occurred during evaluation.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Cluster URI: WABI-AUSTRALIA-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 15702bcf-3854-4907-9da3-aa719dded4fe
Request ID: 06305dc0-ff5a-caa0-3260-31687bfc226d
Time: 2022-02-18 03:46:06Z