Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have basically two tables with each one having a field about the country. Both fields are declared as text in the Query Editor.
I am trying then to merge these columns fuzzily. In the query editor i don t get any error message.
Afterwards however I get the following error message:
"OLE DB or ODBC error: [expression error] We only support text columns for fuzzy join operations. The column 'Country1' is not of type text..."
In my opinion, this is a bug. Or do i miss something?
I am running the version 2.68.5432.841 64-bit (April 2019)
Here is the code of my fact table.
let
Source = Excel.Workbook(Web.Contents("https://myhavi-my.sharepoint.com/personal/kahfatt_chan_havi_com/Documents/Power%20BI%20Portal%20Work..."), null, true),
Incidents_Sheet = Source{[Item="Incidents",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Incidents_Sheet, [PromoteAllScalars=true]),
#"Excl GSOC = yes" = Table.SelectRows(#"Promoted Headers", each ([GSOC] = "--")),
#"Call fIncidentsRequests" = fIncidentsRequests( #"Excl GSOC = yes"),
#"Appended Query" = Table.Combine({#"Call fIncidentsRequests", #"CSAT Requests"}),
#"Changed Type" = Table.TransformColumnTypes(#"Appended Query",{{"Country", type text}}),
#"Trimmed Text" = Table.TransformColumns(#"Changed Type",{{"Country", Text.Trim, type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Trimmed Text",{{"Country", "Country1"}}),
#"Merged Queries" = Table.FuzzyNestedJoin(#"Renamed Columns", {"Country1"}, DimCountries, {"Country"}, "DimCountries", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=true]),
#"Expanded DimCountries" = Table.ExpandTableColumn(#"Merged Queries", "DimCountries", {"Country"}, {"DimCountries.Country"})
in
#"Expanded DimCountries"
Cheers. G.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.