Downloading Data through Power Automate

Hi Anonymous 

This is what I've did for this usecase

First step,

You have to run a query against dataset, to get the query you need

Open Power BI Desktop, create a table with all the fields you need

Then go in optimize Performance analyzer; in the pane click on Start recording and refesh visual and copy query

(You can remove the total of the table before to refresh visual)

Then in Power Automate, you paste the code in a run query against dataset (you have to select your workspace and your dataset)

Then in Power automate you add a select from Power Automate

the tricky part is to make the mapping, to do that, you have to use the following formula instead of entry value

item()?['[your fieldname]']

Once you will save, the formula should appear as a power bi item

Then create a csv table using the output of the previous step

And then use an action to publish this csv on a sharepoint site or a public place (like a blob storage with a public access)

In my case, I used an amazon S3 Bucket

For the refresh, you have to schedule your dataflow at the frequency you need

Do not hesistate to ask if you need more help 🙂