I have this query:
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.