Forum Discussion
TobiasKitchen
7 years agoNew Member
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...
TeigeGao
7 years agoSolution Sage
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
7 years agoNew Member
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 :)