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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PBIn00b
Advocate I
Advocate I

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

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!:
The Definitive Guide to Power Query (M)

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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors