The most easy solution would be if the Power BI connector in Power Automate included an option like 'Get Data from Power BI DataSet', and in that allowed to define a query on data to extract. Question: I wonder if there are less complicated ways than those mentioned below? The value from the Card is included with the Alert, and other columns in the Sharepoint list item can be populated too.įor multiple datapoints (Rows and Columns) there are several options, but with various levels of complexity.
PBI DataSet => PBI Report => PBI Dashboard with Card => PBI Alert => Power Automate. Request comments on the data, which is a very common business scenario. identified with PAFnow Process Mining analysis. Create deviation notifications to act on, e.g. Store snapshot status of aggregated data, as historical records from where trends then can be presented. The objective is to move data from Power BI DataSets to Sharepoint on-line Lists, to support use-cases like This post is partly a description on how to do this, but it also includes some open questions to welcome a discussion on how to do it better and more effective.