Expression.Error: Value=FALSE Type=Type

[gsalas]

HELP!  Having serious issues with an attempted Merge Queries.  I am trying to merge an index key for the combination of Month, Year, and Keyword onto a Table with all leads.  Some of these leads will have a match in the index, but not all (since many of the leads are from other tactics like display).  When I merge the queries (Left Outer Join) and then attempt to exapnd the New Column so my index shows for each item, I get the following error message:

Expression.Error: We cannot convert the value false to type Text.
Details:
Value=FALSE
Type=Type

I cannot find this error anywhere else.  Since it is a left outer join, I should get an empty value NOT a FALSE values for every row where the match failed.  Thanks for your help!

[Vvelarde]

Maybe the issue is the Index Key (The combination).

[gsalas · Accepted solution]

I found the issue.  Apparently two records in one of the index columns were labeled "FALSE" in the source excel data.  Power Bi cannot process cells in excel that have a classic error flag like "FALSE" "#NAME?" or "#DIV".  Once I cleared the records, the indexing worked beautifully.  Thanks!

[goda]

Thank you for sharing, I was losing my mind with this error 😂 But after seeing your comment saying Excel special flags are to blame, I just saved the source file as a csv instead of xlsx and that fixed it!