Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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

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. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.