Power Platform Community Forum Thread Details

How to load Dataverse Elastic type Flow_Run table data into Power BI Deskstop using Dataverse . am able to load standard type table data into Power BI . Please help me to resolve this issue. is there any other approach to load the Elastic type table data into Power BI

Categories:

Microsoft Dataverse with Power Apps

Natively this internal table aren't exposed.

Elastic tables like Flow_Run aren’t exposed in standard Dataverse APIs.
That’s why Power BI’s native Dataverse connector (which uses OData endpoints) can’t load them—unlike standard tables (like account, contact).

There is an options to Load Elastic Table Data into Power BI but it is bit complex and use other microsoft tools as well.

1. Power Automate (Export Data)Since Flow_Run data is essentially about Flow execution history, you can:

Create a Power Automate flow to query flow run history via the Power Automate Management connector or Power Automate API.
Save that data into a standard Dataverse table or an intermediate data source (like SharePoint, SQL, Azure Table Storage).
Then, use Power BI to load from that standard source.

2. Use Power Automate or Azure Data Factory (ADF)If the data volume is high:

Use ADF or Power Automate to periodically export the data to an external data source (Azure SQL, Blob Storage).
Power BI can easily connect to that external source.

3. Export to CSV / Data LakeSome organizations choose to export Elastic table data to Data Lake via Dataverse’s Export to Data Lake feature (requires premium licensing & setup).

Once exported, Power BI can connect to Data Lake Gen2 using the Azure Data Lake connector.

Leverage the Power Platform Admin API For example, using the Power Automate REST API:

GET https://management.azure.com/providers/Microsoft.ProcessSimple/environments/{environmentId}/flows/{flowId}/runs?api-version=2016-11-01

You can pull Flow run data programmatically and push it to a Power BI-friendly source.

Like the answer if it help.

Community site session details

How to load Dataverse Elastic type Flow_Run table data into Power BI Deskstop using Dataverse .

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates