Visual table download misses data

[almay]

Hi, I have exhausted all possible explanaitons, hoping to solve it with community help.

I have created a report in Power Bi Query with multiple filters. I display this report as a table in visuals and users need to download that table as Excel. In queries I have 916 rows, in the visual table total count of rows gives me 916. However, when I download that table to Excel, I only get 778 rows. Consistently losing 138 of them each time I and other users download it. No filters applied in vusuals whatso ever! 

Interestingly, when i go to filter and search for one of those missing 138 records by their fields they do not appear in the visual table even though total count of rows in that table shows 916 (meaning they are there but not visible). No obvious pattern in those missing records, they just somehow get excluded. 

I am completely puzzled with that. 

Is there anything you could think of that explain that behaviour? Any tricks with downloading data that I dont follow? thanks

[almay]

yup, once I enabled "Allow users to export underlying data sources", the full report was downloadable. I dont even understand why sujmarised data download option is there, it seems to be creating more problems than it solves.

Many thanks

[V-lianl-msft · Accepted solution]

Hi @almay ,

In Power BI Desktop, you'll only have the option to export summarized data.

The solution is to create an index column or other unique column so that the data is not summarized, or filter the data in the query editor and copy the table and paste it into excel.

If it's in service, make sure the pbix file "allow users to export underlying data sources" is enabled in desktop. And make sure that "export data" is set up correctly in the service admin portal, and whether the user has edit permission or build permission on the dataset in the workspace.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11]

Hi @almay ,

Can you try adding a unique INDEX column to your visual table and then check how many records are shown on the visual and how many of them get downloaded?

Thanks,

Pragati