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 i am looking for a way to encode a guid into base64
663e6ca3-31cd-4886-a90a-21a6ed8a =>
Zj5sozHNSIapCiGm7YqJbQ==
Tool: GUID Converter - Tool Slick
In code this would look like this:
$guid = "663e6ca3-31cd-4886-a90a-21a6ed8a" $base64 = [system.convert]::ToBase64String(([GUID]($guid)).ToByteArray()) $base64 |
Please see if the approach used in this article works for you.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I tried the same - problem is it doesnt use the GUID as HEX value but just converts the string. Which result do you get.
Not sure where you got your result from but here's a Power Query version.
let
Source = Table.FromRows({{"663e6ca3-31cd-4886-a90a-21a6ed8a"}},{"GUID"}),
#"Added Custom" = Table.AddColumn(Source, "Base64", each Binary.ToText(Text.ToBinary([GUID],BinaryEncoding.Base64)))
in
#"Added Custom"
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.