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 receiving this error with my query, and I can't understand why. I've checked some other topics for this issue, but haven't found a solution. In order to isolate the problem, I went from the end of my query and deleted every step until I found where the error was occuring, and it seems to be happening when I merge two queries together. This is where the problem happens:
#"Merged Queries2" = Table.NestedJoin(#"Added Conditional Column3", {"lookup for case name"}, #"raw data", {"Contract ID"}, "raw data", JoinKind.LeftOuter),
#"Expanded raw data" = Table.ExpandTableColumn(#"Merged Queries2", "raw data", {"CBT", "CT", "Case"}, {"raw data.CBT", "raw data.CT", "raw data.Case"})
If I delete the Table.ExpandTableColumn step, the error goes away. I've checked the columns in my raw data file, and there are no nulls there. I can't figure out what null it's trying to convert. Any help?
thanks,
Hi @Anonymous ,
This happens if you have mixed data types in your column to expand, please check the #"Changed Type" step in previous.
Best Regards,
Teige
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.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |