Forum Discussion
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...
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.
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?
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.