Power Automate flow against Power BI dataset returning incorrect amount of rows

[taikuri]

Hey!

I have this query:

EVALUATE
FILTER(ExportTable,  ExportTable[Date] >= DATE(2022,7,7) && ExportTable[Date] <= DATE(2022,8,12) && CONTAINSSTRING(ExportTable[CustomerName], "CompanyName") == FALSE() )

When I run the query in Dax studio I get the correct amount of rows (42k) but when I run the same query in Power Automate, create a csv file from it and store it in SharePoint or through SFTP I get an incorrect number of rows (15k). If I run the flow month by month for the same time period I get a correct number of rows. Any ideas about what is causing the problem and what could be a solution? There are reasons why this has to be run in Power Automate and not just save the data from the DAX studio query so that is not a solution. 

[taikuri · Accepted solution]

Found a possible solution to this one. Seems like there is a row and value limit in DAX queries run in the power automate. To get further info check out this link. https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries#limitations