Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am connecting snowflke view to create a report. I have almost 100 + column with header name like "TEXT_TEXT1" . I need to change header to proper case and removing _ to " Text Text1" column headers. Us there any quick way to do this using functions.
I am trying to use functions but no luck as this is a view not a table.
Can I do this using direct query connection or have to use "import " connection ? Please help
Solved! Go to Solution.
@mpk
You can simply do it in Power Query in 2 steps:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("NY3JDQAxCAN74Z1HAuFILVH6b2MxaD8ja4TNvSRGg3Yk9CRM6I20DrsSayeirUtmRyEKUZZhZWIBia2sVQ92w+psW5P8j4f3guIC4NMv3/sA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [TEXT_TEXT1 = _t, TEXT_TEXT2 = _t, TEXT_TEXT3 = _t, TEXT_TEXT4 = _t]),
Replace_ = Table.TransformColumnNames(Source, each Text.Replace(_, "_", " ")),
PropperCase = Table.TransformColumnNames(Replace_, each Text.Proper(_))
in
PropperCase
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@mpk
You can simply do it in Power Query in 2 steps:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("NY3JDQAxCAN74Z1HAuFILVH6b2MxaD8ja4TNvSRGg3Yk9CRM6I20DrsSayeirUtmRyEKUZZhZWIBia2sVQ92w+psW5P8j4f3guIC4NMv3/sA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [TEXT_TEXT1 = _t, TEXT_TEXT2 = _t, TEXT_TEXT3 = _t, TEXT_TEXT4 = _t]),
Replace_ = Table.TransformColumnNames(Source, each Text.Replace(_, "_", " ")),
PropperCase = Table.TransformColumnNames(Replace_, each Text.Proper(_))
in
PropperCase
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
thank you 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.