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,
I have not worked with Direct Query yet, so I tried to read up on it. It seems like it kinda depends on your data source, when you are using Power Query. Have you tried creating the new column in DAX? Does it return the same error message?
This seems a great resource that many other threads were referring to:
Using DirectQuery in Power BI - Power BI | Microsoft Docs
Solved: M for Calculated Column in Direct Query Mode - Microsoft Power BI Community
DirectQuery in Analysis Services 2016 - SQLBI
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/