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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
PBIn00b
Advocate II
Advocate II

PBI Online not showing all the data

I am using the same dataset in PBI Online as I am in PBI Desktop.  When I refresh, PBI Desktop shows all the data properly, however PBI Online isn't showing all the data.  All my other data sets seem fine, but this one just isn't working correctly.  Also, this dataset pulled fine just a few days ago.

 

For instance I have data from 2008 - 2016. 

PBI Desktop shows data from 2008 - 2016. 

PBI Online shows data only from 2009 - 2010

 

I have tried re-entering credentials, moving my gateway, refreshing the data, verifying my filters, etc...

 

Any ideas?

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

That sounds very odd. Is this after you publish from PBI Desktop or is your Desktop and Service reports refreshing independently from one another?

 

Where are you seeing that PBI Online only shows data from 2009-2010? Dashboard, Reports, Dataset? The reason I ask is that Dashboard tiles keep the filters they hand at the time that they were pinned. You could always "explore the dataset" and create a simple table with no filters to check to be sure.

 

What is the status of the last refresh on your dataset, if you are refreshing it that way in the Service?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Hi smoupre, thanks for the quick reply.

 

They are refreshing independently, but I have tried publishing from Desktop to see if that changed the result.  It didn't.

 

I am seeing this in the actual report, not the dashboard.  I have tried making a clean report with the dataset and I get the same result.  Also, my refreshes are showing successful.

 

EDIT: Something even stranger.... now the data seems accurate. I haven't changed a thing.

Hmm, that's mysterious. Wonder if there was some kind of caching issue or something? The one downside to cloud, it is very much a "black box" so weird things can happen and there is no troubleshooting. Glad you got it fixed!



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

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

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.