New source in the folder - [Data Source Not Found]

[Anonymous]

Hello

I'm getting data to Power BI from Power Query. Source is a folder on my desktop that contains 3 files with the same data structure (just different values inside).

When I add a new file (again - same data structure, just different values) I have an error message:

[DataSource.NotFound] Excel Workbook: 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 '0504 BDR Sweden.pbix'. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.

Does anyone have an idea how to solve it? All of the files are ".xlsx" Excel files. It has nothing to do with Access...

Thank you!

[TomMartens · Accepted solution]

Hey,

wondering if you already checked the obvious that is, please check if the new file is of the same data type, ideally xlsx.

But nevertheless, from the error message it seems that a pbix file is inside the folder, maybe it will help to store the pbix outside of the folder that contains the source files.

Please be aware, that Power BI scans the folder recursively, meaning either you store the pibx next or above the source files or you just use a filter inside the Power Query query to exclude the pbix file.

Hopefully this provides you with some ideas.

Regards,

Tom

[Anonymous]

I cut the file outside the folder where I have the data and it works! 

thank you so much 🙂 @TomMartens