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:...
johnihab's avatar
johnihab
Frequent Visitor
5 years ago

Hello I experienced that problem, maybe the reason is Excel File is Read-Only or you don't have the permission to edit it, So maybe it is better to convert it to CSV or Text

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI Johnihab

I couldn't work out the problem - permissions seemed ok and file wasn't read only.

Strange as the data came in but ok but the error appeared when tried to merge with another table.

However, your suggested worked and a CSV in the same sharepoint folder worked well

thanks

Related content