Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I keep getting this error when running queries. How do I fix this?
Hi @anaalfonso217 ,
you are doing column conditions where there are values null but you are not giving instructions how to handle the them.
You can either assign a condition for null values or if not needed, use the try-otherwise to avoid these issues.
this function is like iferror in excel.
try (your full condition here) otherwise (what to do if error is found)
Without more information, it's quite difficult to help. From what we can see from your screenshot, there issues in the tables with transformations in columns.
Thanks
Joe
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 8 | |
| 7 |