How to copy a Blob Inventory report to another location via power automate

Hello Jason Morgan

Unfortunately, Power Automate is not supported for processing Azure Blob Inventory reports because inventory paths are dynamic, triggers don’t work reliably on subfolders, and Power Automate cannot access private storage accounts; per‑container reports must be generated using separate inventory rules or processed using Logic Apps, Data Factory, or Functions.

NOTE: This wouldn't work, as Power BI would be looking in a single, fixed container for the source .CSV files and the container path would change each day.

As this something which is not supported. We encourage customers to create a feedback item for this request on the feedback forum

Azure Networking Feedback Forum · Community

Can you please update us if the action plan provided was helpful?

Should there be any follow-up questions or concerns, please let us know and we shall try to address them.

If these answer your question, click "Upvote" and click "Accept Answer" which may be beneficial to other community members reading this thread.

Azure Storage blob inventory itself doesn’t provide per-container reports or direct integration with Power Automate in the provided context. It generates account-level inventory reports (for containers and/or blobs) on a daily or weekly schedule into a destination container in the same storage account, in CSV or Parquet format, plus a manifest file and an Event Grid event for each report.

From the available information, only these supported options are described:

1. Enable blob inventory on a storage account by defining a policy with one or more rules. Each rule can filter by:
   • Blob type
   • Prefix
   • Selected properties/fields to include
2. Inventory reports can be generated:
   • For blobs (base blobs, snapshots, versions, and properties)
   • For containers (with container properties)
   • In CSV or Apache Parquet format
3. Each inventory run produces:
   • The report file(s) in the destination container
   • A manifest file
   • An Azure Event Grid event per report

The context does not describe:

• A built-in way to have Azure Storage emit one separate inventory report per container automatically.
• A Power Automate connector or template that can discover the latest inventory report path dynamically and then copy it to OneDrive.

Only the general pattern is documented: blob inventory is a scheduled automation of the List Containers and List Blobs APIs, and reports are written into a storage container for later processing.

Given the provided information, no supported, documented method is shown to:

• Use Power Automate directly against blob inventory outputs, or
• Configure blob inventory to emit one file per container instead of an account-wide report.

References:

• Azure Storage blob inventory