This Power Automate flow is designed to extract and store summarized Power BI report usage data into Dataverse on a daily or weekly basis. By automating this process, organizations can ensure seamless data updates without manual intervention, directly integrating data from Power BI into Dataverse for easier access and analysis.
This seems to have been particularly true in the world of customer support. Whole businesses seem to have pivoted, turning AI into their central feature as if their very lives depended on it. Some taglines from well-known companies leave no doubt:
Trigger: The flow is triggered every day at 11:00 AM UTC.
Run a query against a dataset: The flow uses the Power BI REST API to run a query against the Power BI report usage dataset. The query retrieves summarized data from the ‘Views’ table, including columns like ‘Date’, ‘DistributionMethod’, ‘GranularViewsCount’, ‘OwnerGroupGuid’, ‘OwnerTenantGuid’, ‘Platform’, ‘ReportGuid’, ‘ReportPage’, and ‘UserGuid’.
Parse JSON: The flow parses the JSON response from the Power BI query to extract the data rows.
For Each: The flow iterates over each row of the parsed JSON data.
