Forum Discussion

TobiasKitchen's avatar
TobiasKitchen
New Member
7 years ago

Data in report does not match Query data for single cell

Hi,

 

I'm having a very strange issue with a report I'm trying to run on the Power BI desktop application.

 

I have source data in two tables that is taken directly from SharePoint and has been merged. It is correct in both the query and on SharePoint itself.

 

However, on the report - a single cell is incorrect. It is a simple yes / no column and the cell states "yes" instead of "no."

 

I have tried many things with filters / transforming / replacing query data but nothing seems to work.

 

As it is just one cell - is there a way to manually change this on report level?

 

I don't have good knowledge of DAX and am fairly new to the system so some help with this would be hugely appreciated.

 

Thanks :) Tobias

Need Help

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    Hi TobiasKitchen ,

    Have you checked the data in the PowerQuery (edit queries)? Generally, the data will not be changed when importing into PowerBI.

    If the data is not true in PowerQuery, we can use the Table.RemoveRows() M function to remove the wrong row, then add another table with a row with true data manually, then append these two tables.

    Best Regards,

    Teige

    • TobiasKitchen's avatar
      TobiasKitchen
      New Member
      7 years ago

      Hi TeigeGao,

       

      Thanks very much for getting back to me.

       

      I managed to solve this one - error was in one of the queries - now fixed.

       

      Really appreciate the help :)