Forum Discussion

mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable Member
10 years ago

Dataset Refresh error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

I built a report using PBI Desktop - the source is an Excel file on a public website (not OneDrive).  When I publish it and then try to use the Power BI site to refresh the dataset, I get this error:...
devhawkio's avatar
devhawkio
Frequent Visitor
6 years ago

I believe I fixed this problem! Use the data gateway to refresh this source.

 

1. Install a data gateway

2. Add the XLS data source to the data gateway

3. Check the box to Allow user's cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster.

4. Set the data source to refresh through the gateway

5. Refresh your dataset

  • Jmenas's avatar
    Jmenas
    Icon for Advocate III rankAdvocate III
    6 years ago

    devhawkio 

     

    Thanks a lot, I will try it and let you know how it works. 

     

    Best,

    Jorge

  • Deckard_X42's avatar
    Deckard_X42
    Frequent Visitor
    3 years ago

    I was facing the same issue and your solution solved it. Thank you. 

Related content