Forum Discussion
Kostya
8 years agoNew Member
incorrect export data to Excel
Hi everybody! In web PowerBI I do the export of dashboard data into Excel tab. I choose "Base data" (the most detalized level of data). But all of a sudden I get incorrect data in Excel. The tota...
Kostya
8 years agoNew Member
Hi @v-jiascu-msft!
Thank you for your help. I did not know about 150K limitation on rows count. In my case this caused a trouble because when I had made a direct SQL query I got 207K rows. Do you know if this limitation is unchangeable or are there any way to increase this 150K parameter in settings?
v-jiascu-msft
8 years agoMicrosoft Employee
Hi Kostya,
I'm afraid the limitation is fixed by now. There is a workaround. You can filter the visual into two parts in your scenario. Then export the data one by one. Finally you can append them as new whole workbook.
Please vote this idea, maybe we can have it in the new future.
Best Regards!
Dale