Forum Discussion
Huge matrix table data export issue
Hi All,
Greetings from K hope you are doing well, I want to export huge no of matrix table data from power bi services set example we habe 160 columns and 10000 rows in matrix table while exporting we getting only 80 columns and rows is fine. can anyone help on this topic seriously it is very very important for me. Thank to all.
Regards
1 Reply
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.
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
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
