cancel
Showing results for 
Search instead for 
Did you mean: 

Underlying error code-2147467259: Linked to Access Database source

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

 

Status: Needs Info

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

Comments
v-mengzhu-msft
Community Support
Status changed to: Needs Info

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

lloane
New Member

Thanks Selina,

 

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.