Publishing to Service - 90% of data lost

[honzarox]

I'm publishing a report from PBI Desktop to PBI Service. The underlying data sits in an Excel spreadsheet of around 400 thousand rows.

When I succesfully publish the report to PBI Service, it consists of only around 40 thousand rows.

I don't see any errors during publishing and the "report" consists of only one page, a table and a few slicers.

Anyone have an idea of where the issue could be?

[v-huijiey-msft · Accepted solution]

Hi @honzarox ,

Hope everything is going well.

Based on your description of the problem, one possible reason is that the data applies Filter in the report. You can check it by following the method mentioned by @GilbertQ , and you can see the filter applied to the visual by hovering your mouse here.

Another possible reason is that the data is summarized in the report. You can check whether there are any aggregates in tables or slicers in the statement. If so, remember to choose “Don't Summarize”.

If you have other questions, please contact me at any time.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[GilbertQ]

Hi @honzarox 

Can you make sure that you have clicked on the reset default button to ensure that there are no filters that might be filtering out your data to only show a subset of the rows?