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 m...
Need Help
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 :)