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.
Hello,
1. I connected to Access Database in a network shared folder
2. Installed Personal Gateway to refresh the data
3. Created Data source
Unfortunatelly refresh is not working at all , I got the below error message
Unable to connect to the data source undefined
Any help.
Regards
Nadir
Update , below is the error
ast refresh failed: Tue Sep 24 2019 11:13:37 GMT+0300 (Arab Standard Time)
Unable to connect to the data source undefined.Hide details
Underlying error code: | -2147467259 Table: Vendors. |
Underlying error message: | Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read 'ProjectsPayments_be.accdb'. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987. |
Hi @nadir ,
You could check if the privacy level settings in Power BI Desktop and Power BI Service are same firstly.
In Power BI Desktop:
Options and Settings --> Data Source Settings
For every Datasource: --> Edit Permissions
Set Privacy Level: e.g. „Organizational“
Power BI Service:
Datasets --> (Choose you Datasets which does not update properly) --> settings --> Gateway Connection --> Actions --> (expand you cluster to show all Data Sources) --> (Choose relevant Datasource) --> Advanced Settings --> Privacy setting --> set same level (e.g. „Organizational) as in Power BI Desktop
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Xue Ding,
Thanks for your reply.
I did that but same problem.
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.