Forum Discussion
Unable to Export Data from PBI server report
Yes, it may be possible using Power Automate. This would also provide the ability to extract all 4 tables to a file with one button click. The trick to get pass the row limit in Power Automate Connector is split the DAX into chunks (a bit like an API call pagination). Try the following as a guide.
Export MORE THAN 100k rows of Power BI data to CSV using Power Automate | No ROW limits! - YouTube
Create a new Excel File in Power Automate and dynamically populate with a Table and Rows #Excel - YouTube
Yes, it may be possible using Power Automate. This would also provide the ability to extract all 4 tables to a file with one button click. The trick to get pass the row limit in Power Automate Connector is split the DAX into chunks (a bit like an API call pagination). Try the following as a guide.
Export MORE THAN 100k rows of Power BI data to CSV using Power Automate | No ROW limits! - YouTube
Create a new Excel File in Power Automate and dynamically populate with a Table and Rows #Excel - YouTube
Thanks a lot for your help, I will take alook at it. 🙂