Works in PBI Desktop but gives error in PBI Online:We cannot convert the value "[List]" to type List

[VValdivieso7]

Hello,

I'm trying to do a find and replace text (trying to replace some typos, etc.) in my main dataset ("CompManufacturer_Name_Fix") by using a list of words that I have identified within the find and replace supporting list ("Find_Replace1"). I saw this video and I followed the same steps after minute 3:54. It worked perfectly in PBI Desktop (no errors whatsoever) however I had to recreate it as a Dataflow (PBI Online) and it is giving me the following error:

Expression.Error: We cannot convert the value "[List]" to type List.

Details

Value = [List]

Would you know why? I'm really struggling with this one. Any help is appreciated!

Details:

Find_Replace1:

1. I add a Custom Column to create a list using the following code:

Table.AddColumn(#"Changed column type", "Custom", each {[Find],[Replace]})

2. I delete all othe columns except the new Custom Column and finally convert the custom column to a List.

Main Dataset:

1. I take the "Competitor Manufacturer" and create a Custom Column "Competitor by Word" create a list that splits the words using the code: 

Text.Split([Competitive Manufacturer], " ")

2. I create a Custom Column "v.Competitive Manufacturer" to replace text and to combine the words into a 1 by using a space a delimeter by using the code:

Table.AddColumn(#"Competitor by Words - List", "v.Competitive Manufacturer", each Text.Combine(List.ReplaceMatchingItems([Competitor by Word], Find_Replace1), " "))

Here is the Error I get:

In my PBI desktop version I don't get any errors:

To confirm, I get an error in the PBI Online (to create the Dataflow) but not in the Desktop version. I need to get it to work in the PBI Online version.

Thanks for your help!

[v-kkf-msft]

Hi @VValdivieso7 ,

It was able to execute successfully in my dataflow. Please make sure your "Find_Replace1" is a list.

Best Regards,
Winniz

[VValdivieso7]

Hi Winniz,

Thank you so much for looking into this!

To confirm, you are doing this in PowerBI Online?

When I do it in the Desktop version it works without a problem but when I do it Online is when I get the error.

I checked my Find_Replace1 and it is a List - I'm still getting the error.

[VValdivieso7 · Accepted solution]

I was able to overcome the error by copying the entire PB Desktop Query and pasting it into the Dataflow. Not sure how/why but it is no longer giving me an error. Either way, thanks for your help!!