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

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. Get the code shown in the video here: https://curbal.com/curbal-learning-po... Chapters: 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 All Export videos here:    • Export data from Power BI   Here you can download all the pbix files: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI!    / @curbalen   Our PLAYLISTS: Join our DAX Fridays! Series: https://goo.gl/FtUWUX Power BI dashboards for beginners: https://goo.gl/9YzyDP Power BI Tips & Tricks: https://goo.gl/H6kUbP Power Bi and Google Analytics: https://goo.gl/ZNsY8l ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: https://curbal.com/courses-overview ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ************ MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too! COUPON: CURBAL10 Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance! ************ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► https://goo.gl/3VW6Ky Twitter ► @curbalen, @ruthpozuelo Facebook ► https://goo.gl/bME2sB #CURBAL #SUBSCRIBE