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.
Set up your dashboard
To set up your monitoring dashboard for dataflow refresh history:
Navigate to Power Apps.
Select the environment you want to monitor.
Open Settings > Session Details.
Copy the Instance url, which should look something like
contoso.crm.dynamics.com
.Download the Power BI Template.
Open the template file with Power BI Desktop and provide your instance URL.
Select Load.
If this is the first time you've used this dashboard, you might need to enter your credentials to sign in.
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
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:
Navigate to Power Apps.
Open the Dataverse tables overview.
Navigate to the managed tables section.
Scroll down to the dataflow refresh history tables.
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 perform 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:
- Use Dataverse to build a dataflows monitoring report
- Use a Power BI semantic model to build a dataflows monitoring report
- Use Excel to build a dataflows monitoring report
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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for