Failed to refresh the data - Access Database in a shared folder

[nadir]

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

[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.

• 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-msft]

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.

[nadir]

Hi @Xue Ding,

Thanks for your reply.

I did that but same problem.

Regards