cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft sonam7
Microsoft

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

Accepted Solutions
Super User I
Super User I

Re: Difference between data in Query Editor and Data View

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  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



View solution in original post

1 REPLY 1
Super User I
Super User I

Re: Difference between data in Query Editor and Data View

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  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors