Moved Excel-files (SharePoint) keeps showing up in Power BI report

[MathildaBackman]

My Power BI report has a folder (A) in a library in SharePoint as a source.
In that folder (A) we keep Excel files created in the last 180 days.
A Power Automate flow moves files from that folder (A) to another folder (B) to keep them older files in an archive.
No files are deleted. Just moved from (A) to (B).
The folders are in the same library.

My Power BI report is connected via API and import mode and it keeps on showing those moved files allthough we update and refresh that report.
Seems like it is retrieving Metadata even though I try to exclude hidden files.

What is the problem and how do I solve it?
The solution has to have SharePoint as source.

[danextian · Accepted solution]

Hi @MathildaBackman 

I would inspect each applied step in the query editor to check what files are visible. Also, you are using Text.Contains so check whether the folder path of  old files does not contain the LibraryPath variable. Make sure that LibraryPath points to the new files folder and not to the same parent folder the old and new files folders are in.

[MathildaBackman]

Thanks, @danextian 

This was the problem:
"Also, you are using Text.Contains so check whether the folder path of  old files does not contain the LibraryPath variable. "

We have changed the name for (B) so now only files in (A) is loaded.