Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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!
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!
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
82 | |
64 | |
62 | |
56 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |