I have a PowerBI report where the source data is from an Access Database stored on a server.
When the report is linked to a Personal Gateway, the refresh schedule works fine.
When it is linked to an On Premises Gateway stored on a Remote machine, the refresh does not work and we get the below error.
I have checked the remote machine and the user the machine is logged in on has access to the source file.
Underlying error code-2147467259
Underlying error messageUnspecified error
Hi @lloane .
Notice that you said you use personal gateway to link data source?
Please install standard gateway and use it.
Install an on-premises data gateway | Microsoft Learn
Community Support Team Selina zhu
The refresh is linked to a on-premises data gateway stored on a remote machine. This is when the refresh fails. It only works when linked to a Personal gateway.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.