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.
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
Solved! Go to Solution.
Hi @HaveeshPerla_1 ,
The Access database is supported by Gateway, you can find the details in this official documentation.
1 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
Hi @HaveeshPerla_1 ,
The Access database is supported by Gateway, you can find the details in this official documentation.
1 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
2 | |
2 | |
2 |