The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |