Unanswered

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

(0) Share

Report

Posted on 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.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

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'))

Was this reply helpful? Yes No
Verified answer

gmorissette 19 on at

Like (0)

Report

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'])

Was this reply helpful? Yes No