Table Not showing all records when exporting in service

[Pandu473]

Hi All,

When i am extracting the data form the table it is giving only few data not complete. However count is mataching as per card and also the raw data. 

Kindly help in fixing this issue

[ibarrau]

Hi, how are you exporting? how many rows are you expecting?
There are two ways of exporting.

• Export summarized data: Select the option for Summarized data if you want to export data for what you see in that visual. This type of export shows you only the data (columns and measures) that are being used to create the visual. If the visual has an aggregate, you'll export aggregated data.
• Export underlying data: Select this option if you want to see the data in the visual and additional data from the dataset (see chart below for details). If your visualization has an aggregate, selecting Underlying data removes the aggregate. 

Remember you have limitations like:

• The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000.

• The maximum number of rows that the applications can export from an import mode report to an .xlsx file is 150,000.

More info: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-summariz...

I hope that helps,

[Pandu473 · Accepted solution]

Hi,

I am follwing the first option of exporting summarized data, however i found the issue. It was with one of the mesaure which calucaltes Avg value hence it is not extracting all details due to this. 

Thank you so much for your help and now issue is fixed.

[ibarrau]

I'm glad you fix it. If my last answer has helped, then please consider Accept it as the solution to help the other members find it more quickly.

Regards,