Forum Discussion

G_Terry's avatar
G_Terry
Regular Visitor
11 months ago
Solved

Power BI Service - Failure to Refresh

     We have a Power BI Desktop report, based on an Access 365 database, that we periodically publish to the Power BI Service. We utilize a gateway server for the Power BI Service connection to the d...
Need Help
Show and Tell
  • v-tejrama's avatar
    v-tejrama
    11 months ago

    Hi G_Terry ,

     

    Thank you for the update. Since the gateway has been patched and your admin is reviewing the Access driver registration, you are proceeding correctly. At this stage, it is advisable for your admin to examine the gateway logs on the server, as these logs can help determine whether the issue is related to the Access driver, file path permissions, or the gateway service itself.

     

    If the driver is functioning properly and the logs do not clarify the cause, submitting a support ticket to Microsoft would be the most effective next step, as their team can perform a detailed log analysis and provide further guidance.

    Thank you,

    Tejaswi.

v-tejrama's avatar
v-tejrama
Community Support
11 months ago

Hi G_Terry ,

 

Thanks for sharing the details. Since the refresh is working in Power BI Desktop but failing in the Service with DataFormat.Error, it usually points to the gateway setup rather than the query or the Access file itself. Please update your On-premises data gateway to the latest version and install the matching Microsoft Access Database Engine (generally 64-bit) on the gateway machine.

 

Also, ensure you are using a UNC path instead of a mapped drive, and confirm that the gateway service account has read access to the file and folder. At times, differences in regional settings between Desktop and Service can also cause this error, so it’s safer to explicitly define date/number formats in Power Query and check for unexpected nulls or text values in numeric/date columns. 

 

If you have validated these and the issue still persists, the best next step is to raise a support ticket through the Power Platform Admin Center so Microsoft can review the logs https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Thank you,
Tejaswi.