Forum Discussion
Captilize each word in Direct Query
Hi BI Gurus
i have a column say "Node Name" which has multiple words(Ex: PRIVATE DEBT AND LOAN,DIRECTLY HELD INVESTMENTS etc) retrieved thru Direct query.
i want to change it to Capitalize each word Private Debt And Loan, Directly Held Investments
i have tried below and it gives error that the source should be converted to import mode before using it
1.Captilize each word in power query
2.m code Text.Proper(Node Name)
is there a way to achieve this in DAX .. Please pass the DAX sample if available when Direct query is used
Thanks
Ajay
Hi ak77
The problem with Dax here is that you can't add a column with direct query mode.
I don't think that there is a solution from power bi.
But,
You can modify it from the connectionIn the datasource connection --> Advance options --> Specify the Select query.
Example : select upper(colname) Col1, upper(colname) Col2 from table1,etc....
Please see linked discussion:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
1 Reply
Hi ak77
The problem with Dax here is that you can't add a column with direct query mode.
I don't think that there is a solution from power bi.
But,
You can modify it from the connectionIn the datasource connection --> Advance options --> Specify the Select query.
Example : select upper(colname) Col1, upper(colname) Col2 from table1,etc....
Please see linked discussion:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.