Sep 24, 2022 12:00 AM

Export MORE THAN 100k rows of Power BI data to CSV using Power Automate | No ROW limits!

External YouTube Channel

In this video I will show you how to batch the Power BI exports so you don't hit the Power Automate limit of 100k rows.


00:00 Intro

01:40 Code1: Flow to export Power BI data using Power Automate (will hit the limit)

03:15 Explain the logic first

05:50 Modify the flow to batch the exports

06:00 Initialize the row and increment variables

08:15 Code2: Count number of rows in Power BI

09:40 Code3: Convert the array to number

12:00 Start the loop

13:00 Code4: Rewrite the DAX code to filter the tables

14:30 Increment the variables

18:00 Append all exports to one file