Syntax error with if statement

[Akos90]

When using "contains" in the "add conditional column" dialog, the query runs on syntax error:

corresponding M code:

Datasource is in import mode!

[ilyagithub1]

@Akos90 Could you please provide more details about the query?

More information is required to reproduce this issue, for example:

• A zip with Power BI Desktop traces. See How to generate Power BI Desktop traces? for instructions. Remember to click Clear Traces folder before tracing is enabled. This will minimize the size of the logs.
• The complete M query.

Preliminary analysis

There's no error in your M line of code or the SQL quoted in the driver's error message. Both code snippets are correct.

The SQL syntax issue might originate from the rest of the query that surrounds the quoted snippet.

Possible causes for the SQL syntax issue:

• A line break or a special symbol.
• A collation issue.

With more details available about the original query yielding the error a more definitive response could be provided.