Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
honzarox
New Member

Publishing to Service - 90% of data lost

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?

1 ACCEPTED SOLUTION
v-huijiey-msft
Community Support
Community Support

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.

vhuijieymsft_0-1708421581578.png

 

 

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!

View solution in original post

2 REPLIES 2
v-huijiey-msft
Community Support
Community Support

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.

vhuijieymsft_0-1708421581578.png

 

 

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
Super User
Super User

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.