How to get Power BI dataset in Power Automate triggered by an email?

[junsarah3000 · Accepted solution]

Thanks but I want to get the dataset. The 3rd action is to email a particular table contents with employees email from that dataset. Power BI dynamic contents are not appearing as selection.

[edhans · Accepted solution]

You will have to create a DAX query, probably in DAX Studio, then use the Run a query against a dataset. It will return a table you will need to parse out and do what you want. Getting the table is easy. Parsing it out is probably a trip to the Power Automate forum to get help on that piece.

Note that your query text must start with EVALUATE. 

If you don't know how to write DAX queries, you can start here. DAX Queries - DAX | Microsoft Learn

There is no click/select/browse or any graphical representation of the dataset to get what you want. You have to use DAX queries to get the data. 

[junsarah3000 · Accepted solution]

Thanks but I want to get the dataset. The 3rd action is to email a particular table contents with employees email from that dataset. Power BI dynamic contents are not appearing as selection.

[edhans]

1. Create an Email trigger. This is an Office 365 email. Just set up the criteria.

2. Add an action to refresh a power bi dataset.

That is it. 2 steps.

[junsarah3000]

Run a query is successful! Is the 4th action "Export to File for Power BI Reports" correct? 

[edhans]

Export to file will work but I am not sure the file format - likely CSV. You could then email that to whomever, but you cannot put the file content in the TO line... Kinda bothers me it allowed that. It should restrict that to text data, and the File Contents should be an object, unless "File Content" is some sort of text descriptor of the file type and there is another "File Contents" object to select.