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...
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!