Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Microsoft Access refresh error

Hello, I have a question how to set up data update in Power BI Service for Microsoft Access source. I'm still seeing an error:   MessageMicrosoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is...
Need Help
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi Anonymous ,

PowerBI gateway only have 64bit one, as a result, when we refresh data via gateway, it requires a 64bit Microsoft.ACE.OLEDB.12.0' provider, we need to install it on the local machine.

The same, a 32bit PowerBI desktop requires a 32bit Microsoft.ACE.OLEDB.12.0' provider, in your scenario, you can install the 64bit Microsoft.ACE.OLEDB.12.0' provider to meet this requirement, we can download it from https://www.microsoft.com/en-US/download/details.aspx?id=13255

Best Regards,

Teige

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello,
    Thank you for your response. However, the data is stored on Sharepoint/OneDrive, so I don't need a gataway for on-premiss. Is it possible to have an Access file in the cloud and set up an automatic update? Thank you!

    • TeigeGao's avatar
      TeigeGao
      Solution Sage
      7 years ago

      Hi Anonymous ,

      How did you connect to the Access file? Using the Sharepoint connector? 

      Best Regards,

      Teige

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello, thank you for your quick response.
        I have data connected as SharePoint. Is any other functional connection possible? Or how to connect data from the cloud to Power BI Desktop / Service? Thank you