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 ...
In many marketing/analytical related scenarios, you would have core business solution data (like Dynamics 365 Sales) made available in an Azure SQL DB, for example telco with 7 million customers. Slice and dice this customer set into 1,6 million rows so you can create a segment in Dynamics is not possible due to these export limitations.
