Forum Discussion
Failed to refresh the data - Access Database in a shared folder
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. |
- Before I had Access 32 Bit & Power BI 64 Bit
- I uninstalled the Whole Office and Installed Office 64 bit including Access
I installed the Access Database Engine for 64 Bit
Still facing same problem
v-xuding-msftCommunity Support
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