Forum Discussion

j0710's avatar
j0710
Frequent Visitor
2 years ago
Solved

Modifying DAX Query for Large Dataset in Power Automate "Run a Query against a Dataset"

I have created a table chart using a field parameter with more than 1000 rows in Power BI. In Power Automate, I am using the "Run a Query against a Dataset" action, and I require assistance in modify...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    2 years ago

    Use a Table visual in Power BI to collect the columns and measures you need, with the required filters applied.  Disable Row Totals. Then grab the resulting DAX - you will see that it is much simpler.  Finally remove the TOPN limiter.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Use a Table visual in Power BI to collect the columns and measures you need, with the required filters applied.  Disable Row Totals. Then grab the resulting DAX - you will see that it is much simpler.  Finally remove the TOPN limiter.

Related content