Forum Discussion
Power BI Service - Failure to Refresh
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.
Hi G_Terry ,
Thanks for sharing the additional details. Since the refresh was working earlier with the gateway and the 64-bit Access driver, but later stopped with the “unspecified error,” it means the original setup was fine and something in the environment has changed. In such cases, the most common causes are either the Access driver getting unregistered after a Windows update, or the gateway service account losing permissions to the shared folder where the Access file sits.
I would suggest confirming that the driver is still properly installed on the gateway server, checking if the service account has uninterrupted access to the UNC path, and verifying that the file itself has not been moved, renamed or locked. The gateway logs (found under C:\Program Files\On-premises data gateway\GatewayLogs) will normally point to the exact issue. If none of these checks resolve it, raising a support ticket would be the right step as the logs will help the support team narrow down whether it is a driver, permissions, or gateway service problem.
Thank you,
Tejaswi.
Hi G_Terry
I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.
Thank you.
Hi G_Terry ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you,Tejaswi.
Sorry for the late reply. The admin I'm working with at corporate indicated that the gateway server had been patched to the latest version. I've indicated to him to check for an unregistered Access driver, which he said he woul do today. So we'll see. Also, to check th logs on the server. Wish I could do that myself, but the only access I have to the gateway server is creating the connection through Power BI web.
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.
