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

  • sasdfasdfsad's avatar
    sasdfasdfsad
    Advocate IV
    10 months ago

    A follow question if you don't mind, what is the row limit for that operation?  How many rows can be returned through Power Automate?

    • lbendlin's avatar
      lbendlin
      Super User
      10 months ago

      As far as I remember it is a payload size limit (rows times columns, up to 100 MiB), not a row limit. Use chunking/paging.

Related content