Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
Microsoft.Data.Mashup.ValueError.Detail filename.accdb
Microsoft.Data.Mashup.ValueError.ReasonDataFormat.Error
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Best regards,
Community Support Team Selina zhu