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
sonam7
Microsoft Employee
Microsoft Employee

Difference between data in Query Editor and Data View

Hi All,

 

I have come across a wierd issue and have no idea how to resolve it.

 

I have a table that has the following columns:

  1. [Build] 
  2. [Branch]
  3. [Total]
  4. [Successful]
  5. [Attempted]
  6. [Score]
  7. [BuildDate]

When I import this sql view in powerbi I see the correct values displayed in the query editor. Please reference the screenshot below:

 

QueryEditordata.PNG

 

However, as soon as I load the data and I look at it in Data View the numbers are not the same as query editor. The numbers displayed in Data View are not correct and should match the one's in Query Editor.

 

DataViewdata.PNG

 

Methods tried to fix this problem are as followed:

  • Disabled the relationship KPIScore table has with any other table - no change
  • Removed the filters from the page - no change in values
  • Imported just the KPIscore table in a new powerbi file and it works as expected

 

Please tell me what's the issue here and what I need to do to resolve it.

 

Thanks!

1 ACCEPTED SOLUTION
SteveCampbell
Memorable Member
Memorable Member

Unsure without more info, but one reason could be that query editor shows chached data. The view may be from a few days old. You can try clicking refresh preview and see if this updates it

 

Appreciate your Kudos
Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



View solution in original post

1 REPLY 1
SteveCampbell
Memorable Member
Memorable Member

Unsure without more info, but one reason could be that query editor shows chached data. The view may be from a few days old. You can try clicking refresh preview and see if this updates it

 

Appreciate your Kudos
Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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