Forum Discussion

gsalas's avatar
gsalas
Advocate II
10 years ago
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...
  • gsalas's avatar
    gsalas
    10 years ago

    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!

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

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

gsalas's avatar
gsalas
Advocate II
10 years ago

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's avatar
    goda
    Regular Visitor
    3 years ago

    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!