Power Query similar to M365 Migration Manager Scan & Report

[Syndicate_Admin]

I need to make a Power App from Power Query transforms (through which Dataverse may play a role) to scan the filesystem, for marking data for various aspects and properties. While I do have a query starting with Folder.Files, and I am able to filter out unnecessary and temporary files, this is in Excel, I feel there may be a role played by Power Apps here. The issue with Power Query is that it overwrites my table when I run it and scan the filesystem for new folders (it might mess up an index if it was based off of the 2nd folder in the folder hierarchy).  So we need a Power Query to run and use Dataverse? In other words, did anyone have something like a Migration Manager Scan without all the Admin portal stuff, only using Power platform?

[Anonymous]

Hi,

I don't know if this feature could help you. Metadata scanning facilitates governance over your organization's Power BI data by making it possible to quickly catalog and report on all the metadata of your organization's Power BI artifacts. Please refer to

Metadata scanning - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.