Power Automate- Power BI Run a query against a Dataset does not get all rows

Hello all,

Ran into this today.

Make sure you "Query text" is changed to the number of rows you would like to get back. I think it defaults to 500.  I changed mine to 100,000. See below

Blog Type: