cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nadir
Frequent Visitor

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

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

 

3 REPLIES 3
nadir
Frequent Visitor

Re: 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
Community Support
Community Support

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

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.

Highlighted
nadir
Frequent Visitor

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

Hi @Xue Ding,

Thanks for your reply.

I did that but same problem.

Regards

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.