Exporting Power BI data with "Run DAX query against dataset" action in Power Automate
With lo-code we can automate exporting data from Power BI visuals without any REST API knowledge. We need simply copy DAX queries from “Performance Analyzer”, past it in Power Automate inside “run a query against dataset” action . Then we can perform export operation according to our requirements.
In this demonstration, I showed how to copy the DAX query used to get a data visual, which is then pasted into a Power Automate flow, to generate the desired data I would like to export.
Here is a summary of the steps taken to achieve that:
After adding a Power Automate visual, I created an instant cloud flow, in which I added these actions:
-Run query against dataset action:
-Create a csv table
-Create a file in SharePoint / OneDrive
You will find more information in this link
Good stuff. Much more intuitive and easier to set up than the R script example.
but what about if thr sharepoint did not exist in the onedrive ?