Forum Discussion
Trying to create new column by combining a string + column value
Hi Anonymous ,
This seems really tricky because PBI tries to apply the code in a query straight from the data source and depending on the data source itself, it either works or doesn't. I'd suggest you fix that column in the source or you create a view to manipulate the string. Another solution could be to you just use Import mode 🙂 Here a pretty lively discussion about your last error message:
OLE DB or ODBC error: [Expression.Error] We couldn... - Microsoft Power BI Community
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Most Valuable ProfessionalHi Anonymous
Here a solution in Power Query:
Here the code
= "String123 - " & [Column]
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Unfortunately I am using "Direct Query" for the data and that step mentions "This step results in a query that is not supported in DirectQuery mode". Any ideas how to achieve the same result while still using direct query?