Answered

Count the number of rows/records from a Power BI dataset

Like (0) Share

Report

Posted on 24 Sep 2022 02:04:35 by gmorissette

I have a Power Automate workflow that runs a DAX query against a Power BI dataset. How can I count the number of records returned by the query and store this value as a variable to use for conditional logic in the rest of the workflow.

All responses (2)

Answers (1)

Verified answer

gmorissette 19 on 24 Sep 2022 at 09:25:37

Like (0)

Report

Re: Count the number of rows/records from a Power BI dataset

Thanks for the answer but your solution works for an array. A DAX query returns a table, which is an object. In the end, all you have to do it seems is wrap the object inside the length function like so:

length(outputs('NameOfYourDAXQuery')?['body/firstTableRows'])
Sundeep_Malik 6,480 on 24 Sep 2022 at 04:19:50

Like (0)

Report

Re: Count the number of rows/records from a Power BI dataset

Hey @gmorissette
Just use length function ahead where ever you are getting the body of the above dataset.
So for example, after getting the dataset you are saving it in a compose so just write:
length(outputs('Compose'))