Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! 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
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 7 | |
| 4 | |
| 4 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 12 | |
| 11 | |
| 11 | |
| 7 | |
| 6 |