Export to Excel. Underlying and Summarize values are different.

[zlod3y]

Hi All,

I have simple table where I have ProductID, OrderNr and Qty. I have reiceive different values of Qty when I export data as Summarize (OrderNr - Qty) and when I export data as Underlying (ProductID - OrderNr - Qty).

I have found that some lines in orders and whole orders just missed in exported Underlying excel file. Manual check show me that Summarize Qty is correct. Data have about 150K lines, not too much.

Any ideas?

[v-yuezhe-msft · Accepted solution]

@zlod3y,

Do you have pro license and what is the specific row number of your table? Based on this article, the maximum number of rows that can be exported to .xlsx when in the Power BI service is 150,000 for Pro users and 30,000 for Free users.

Regards,
Lydia

[zlod3y]

@v-yuezhe-msft

Thanks for your help. Number of max rows is the answer.