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
Super 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.

j0710's avatar
j0710
Frequent Visitor
2 years ago

Hi lbendlin,

Your insights were incredibly helpful and allowed me to overcome the challenge I was facing.

Thank you for taking the time to share your expertise with the community.
Your contributions are truly valued and make a difference.

Best regards,
jackson
Let's connect linkedin : )
https://linkedin.com/in/jackson-s-652396240

Related content