Exporting Power BI Data to a CSV File using Power Automate (more than 1,000 rows)

Exporting Power BI Data to a CSV File using Power Automate (more than 1,000 rows)

2.920 Lượt nghe
Exporting Power BI Data to a CSV File using Power Automate (more than 1,000 rows)
Power BI has a native feature to export visual data to Excel or CSV. However, it takes multiple clicks and may not be easy to locate or intuitive for report users. Furthermore, there is a limit of sending 1,000 rows with the standard integration with Power Automate. In this video, I show how you can export larger datasets - beyond the 1,000 row limit - from Power BI using Power Automate and Paginated Reports. For a complete writeup of this approach, please check our my blog article at: https://powerbiintegration.com/exporting-data-from-power-bi-to-csv-1000-rows/ 00:00 - Intro 01:02 - Demo 02:57 - Building a Paginated Report 08:17 - Creating DAX Measures for Filtering 11:18 - Building Power Automate Flow 19:37 - Running a Test 20:24 - Conclusion