Monitor your dataflow refreshes with Power BI

When working with any kind dataflows other than Power BI dataflows, you have the ability to monitor dataflow refreshes using Power BI. This article includes step by step instructions on how to set up your own dashboard to share with everyone on your team. This dashboard provides insights into the success rate of refreshes, duration, and much more.

Image of the dashboard with dataflow duration, refresh count, and refresh success rate graphs.

Set up your dashboard

To set up your monitoring dashboard for dataflow refresh history:

  1. Navigate to Power Apps.

  2. Select the environment you want to monitor.

  3. Open Image of a gear. Settings > Session Details.

  4. Copy the Instance url, which should look something like contoso.crm.dynamics.com.

  5. Download the Power BI Template.

  6. Open the template file with Power BI Desktop and provide your instance URL.

    Image of a screen to input your dataverse org URL.

  7. Select Load.

  8. If this is the first time you've used this dashboard, you might need to enter your credentials to sign in.

  9. Inside the dashboard, you'll find two tabs with information about errors, duration, and the count of rows that were inserted, upserted, or failed:

    • Dataflow monitoring
    • Table monitoring
  10. From this point on, you can change the dashboard however you like and publish it to a workspace of your choice.

Where to find the Dataverse tables

The new tables are available in your environment right away. To find the tables in your environment, do the following steps:

  1. Navigate to Power Apps.

  2. Open the Dataverse tables overview.

    Image of navigating to Dataverse section.

  3. Navigate to the managed tables section.

    Image of selecting the managed table section.

  4. Scroll down to the dataflow refresh history tables.

    Image of the two Dataverse tables containing refresh history.

These tables will store history for at least the last 50 refreshes. Refresh history records older than 90 days may be removed by the system. To use these tables, we suggest that you use Power BI to get data through the Dataverse connector. We also suggest that you extract this data into a self-managed table if you would like to do analysis over a longer period of time.

Power BI dataflows monitoring

When working with Power BI dataflows, you might want to check out the following pages for setting up your monitoring solution:

Known issues

In some cases when you try to connect to the Dataverse tables manually through Power BI, the tables might appear to be empty. To solve this issue, just refresh the preview and you should be good to go.