Huge matrix table data export issue

Hi Kanhaiyalal 

 We have very big limitations around exporting the data from visual. Please refer the below limitations. maximum row count is 150000 if it is excel and it will still reduce if the visual is matrix. please cehck.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop#considerations-and-limitations

Solutions:

1. You can use REST API to run DAX query but still limitations are there- https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

2. Consider Paginated Reports - You need to use Report Builder tool to build the paginated reports and you dont have export limit but it requires Premium capacity workspace.

Thanks

Hari