Text.Contains with underscore

Question

Hi there,&nbsp;I'm working with the Power Query editor right now.I have a table connected to my database, and I need to apply a parameter in my request to get some values, else I get an error of query (this is ok).&nbsp;So I've created a text type parameter which help me to get values in my table.but when this parameter contains an underscore, the request fails, as if the underscore split my parameter.&nbsp;Is there any way to include the underscore in the parameter to have my good results please ?&nbsp;Here is 2 examples :&nbsp;- WORKS :&nbsp;&nbsp;Table.SelectRows(dbo_AnalogHistory, each Text.Contains([TagName], "AAA.BBB.CC"))- FAILS :&nbsp;&nbsp;Table.SelectRows(dbo_AnalogHistory, each Text.Contains([TagName], AAA_BBB_CC))&nbsp;Thanks.

chainspart · Accepted Answer

Hi&nbsp;Anonymous&nbsp;and thanks for answering !&nbsp;Fortunately, I found an other way to get my data, using a direct Query with the parameter in the WHERE clause like this :&nbsp;Source = Sql.Database("xxx", "yyy", [Query = "SELECT *&nbsp;FROM [Runtime].[dbo].[History] WHERE [Name] like '%"&amp;ParamName&amp;"%'"])&nbsp;&nbsp;Thanks for trying to help 🙂&nbsp;Now my other problem which I can't find a solution is this one :https://community.powerbi.com/t5/Desktop/Parameter-Binding-Error-Parameter-is-not-defined-in-model/m-p/1933432#M736960&nbsp;Here is the solution :&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Text.Contains with underscore

2 Replies

Related content

Table.Skip won't work with Text.Contains?

Replacing underscore with Space

Text.Contains M Language

DAX does not recognise underscore as an argument

Text.Contain or List.Contain