Getting failed to update Data source credentials error while trying to connect to Gateway.

[Anonymous]

Hi Team,

I'm building a report for which data source is Access Database. I've called the data via Access DB data source in Get data and built the report and published it in Power Bi service. But in data source credentials i'm getting error as "Could not find file" even the path is correct and file is available in that path. 

Kindly help to find me a solution for this. Besides I also want to know is it related to gateway connection and does Access DB support on-Permesis gateway?

Regards,

Haveesh 

[Anonymous · Accepted solution]

Hi @Anonymous ,

The Access database is supported by Gateway, you can find the details in this official documentation.

¹ Supported with the ACE OLEDB provider, installed on the same machine as the gateway.

Regarding to your problem, please review the following link and check if it can resolve your problem.

On-premises data gateway error

A 64-bit version of the Access Database Engine 2010 OLEDB provider must be installed on your on-premises data gateway machine to be able to load Access database files. If you already have a 64-bit version of Microsoft Office installed on the same machine as the gateway, the Access Database Engine 2010 OLEDB provider is already installed. If not, you can download the driver from the following location:

https://www.microsoft.com/download/details.aspx?id=13255

---

Troubleshoot importing Access and Excel .xls files in Power BI Desktop

In addition, you can refer the following thread to add Access data source in the gateway.

Using MS Access as a data source with On-Premises Data Gateway

Best Regards