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.
Hey Power BI Community,
Firstly, HAPPY HOLIDAYS, and thanks for your help on my posts of earlier this year! I'm a data scientist who picked up Power BI to help with an ops project earlier this year, and I've since LOVED it for so many applications (feels like I'm cheating on R + Shiny!).
Anyways, I'm writing because I'm getting a strange error when attempting a Right Outer or Full Outer join/merge. Unfortunately, I cannot share my data, nor pbix (for intuitive reasons), but I here's the error message...
DataSource.Error:
OpportunityFieldHistory WHERE (Field LIKE '%Stage%')
^
ERROR at Row:1:Column:119
invalid operator on id field
Details:
List
It's strange, 1) because the query I'm attempting to merge doesn't have 119 columns, and 2) I have no clue what the Details mean by "list," as the 'id' field in the query I'm looking to merge doesn't contain any list in values or data type. 😕
If you have any ideas, they'd be much appreciated. Have a great day/night!
-Jude C.
@Anonymous,
You may check if the LIKE operator is supported for string fields only.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |