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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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