Forum Discussion
Create a string Column in Advanced Editor
Sorry... But you are all incorrect. I had a different typo. It does work to assign a "string" to a new column in a select statemement:
let
Source = Sql.Database("xxxx", "yyy", [Query="
select
'GDC' as ""Type""
from
[table1]union
select
'bill' as [Type]
from
[table2] bill
"])
in
Source
Community SupportHello SteveApa,
Thank you for reaching out to the Microsoft Fabric Community forum.
Also thanks you, Cookistador for the great insight. string values cannot be directly assigned in the SQL query within Power Query. Instead, you’ll need to add the text column within Power Query after retrieving the data.
- NULL and numeric values work in SQL because they are less ambiguous.
- String values require explicit handling within Power Query.
- The best approach is to add the new column after loading the data into Power Query.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.