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

I wanted to share the solution to an issue I encountered when refreshing a Power BI report connected through the SharePoint Folder connector.

My dataset suddenly failed with a DataSource.NotFound error, and after investigating, I discovered the root cause: in the SharePoint folder where my source file is stored, someone had added a file with a different extension (not .xlsx). Since the SharePoint Folder connector loads all files in the folder, this unexpected file caused my filtering and transformation steps to break.

✔ What fixed it

I added a transformation step to filter the files by extension using:

Column → Filter → “Equals” → .xlsx

This ensures the query only returns .xlsx files, regardless of what else gets uploaded into the SharePoint directory.

✔ Why this matters

When your Excel data source is stored in SharePoint, the connector ingests the entire library or folder. If your query logic relies on positional steps (like “Remove Top Rows”), any new file in the folder will break the transformations.
Filtering by:

• Folder Path, and
• File Extension = .xlsx

creates a stable, future‑proof query.

Hopefully this helps anyone whose Power BI refresh breaks simply because a new file type was added to the same SharePoint folder.