User Profile
jtooke
Helper I
Joined 5 years ago
User Widgets
Contributions
Use Power Automate to extract filtered data to Excel
Hello, I am looking to use Power Automate to allow a user to extract data from a Power BI report to Excel. The data should include any on-screen slicer selections. Due to the data size, I have been looking at doing this through the Power Automate "query a dataset", but I am unable to get the query correct to update dynamically based on filtered selections. I have included a sample screeshot with the page I am looking to extract data from. The slicers pull from the RR table which is related to Table. The columns that will be extracted come from Table. Table IDOverall InherentA InherentB InherentOverall ResidualA ResidualB Residual 1 High Medium Low Low Low Low 2 Medium Medium Low Medium Medium Low 3 Medium Medium Low Low Low Low 4 Medium Medium Low Low Low Low 5 High Medium Low Low Low Low RR IDGroupRating TypeRating 1 Overall Inherent High 1 Overall Residual Low 1 A Inherent Medium 1 A Residual Low 1 B Inherent Low 1 B Residual Low 2 Overall Inherent Medium 2 Overall Residual Medium 2 A Inherent Medium 2 A Residual Medium 2 B Inherent Low 2 B Residual Low 3 Overall Inherent Medium 3 Overall Residual Low 3 A Inherent Medium 3 A Residual Low 3 B Inherent Low 3 B Residual Low 4 Overall Inherent Medium 4 Overall Residual Low 4 A Inherent Medium 4 A Residual Low 4 B Inherent Low 4 B Residual Low 5 Overall Inherent High 5 Overall Residual Low 5 A Inherent Medium 5 A Residual Low 5 B Inherent Low 5 B Residual Low Any help is appreciated, thank you!Using slicer to filter out value from categorical visualizations
Hi, I am looking to use a slicer based on a use case name field (i.e. Use Case 1, Use Case 2, ...). When a use case is selected from the slicer, all of the visualizations on the page should update to EXCLUDE that selected use case. The visualizations would be based on categorical features of the use case - so if the Use Case is Lifecycle = Pilot, then I would want the Lifecycle visualization to show all other Pilot use cases by their risk rating. I have included sample data and a sample output - because Use Case 6 is Production it filters the Lifecycle visual to all Production use cases that have a rating and are NOT Use Case 6. Similarly, because Use Case 6 is in the US it filters the Country visual to all US use cases that have a rating and are NOT Use Case 6. Use Case Name Lifecycle Country Rating Use Case 1 Pilot Nepal Low Use Case 2 Production US Medium Use Case 3 Ideation UK High Use Case 4 Pilot US Low Use Case 5 Pilot China Medium Use Case 6 Production US Use Case 7 Pilot UK Use Case 8 Ideation Nepal
