incorrect export data to Excel

[Kostya]

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 total sum of measurement in Excel is not equal to the total sum on dashboard. I've found out that all negative numbers are not presented in Excel sheet. Are there any solution to this bug?

[Kostya]

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]

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

[v-jiascu-msft]

Hi @Kostya,

I can't reproduce your issue.

1. If you export data from a dashboard, there are no options. The summarized data will be exported. The data will be filtered if you apply a filter.

2. Perhaps you exported data from a visualization. You can choose "Summarized data" or "Underlying data".

Please check the following things:

1) If there are any filters.

2) If they are summarized data.

3) If the records exceed the limits. 30000 rows for .csv and 150000 for .xlsx file.

4) And more limitations, please refer to: limitations-and-considerations.

Best Regards!

Dale