Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.