Forum Discussion
Solved
Expression.Error: Value=FALSE Type=Type
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...
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!
Maybe the issue is the Index Key (The combination).
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!