In late 2016, Power BI improved our export data options to allow exporting up to 150,000 rows to Excel from a visual on a Power BI dashboard for Pro users. If you require higher limits, please vote ...
Please set the export limit to the current excel worksheet row limit less 5 row header space and keep them pegged together. There are many times when power users need to build an excel model off of dashboard data for future scenario analysis. Getting that data from the same source as the power bi dashboard would make this process much easier.
