Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
How to decode JWT access_token in power query?
GetMetadataTable= () as any =>
let
currentCredential = Extension.CurrentCredential(),
access_token_decoded=currentCredential[access_token],
decoded_token= ???
in
decoded_token;
Something like this: https://jwt.io/
Thanks
Solved! Go to Solution.
let
Token = "<snip>",
Base64Url.Decode = (s) => Binary.FromText(Text.Replace(Text.Replace(s, "-", "+"), "_", "/") & {"", "", "==", "="}{Number.Mod(Text.Length(s), 4)}, BinaryEncoding.Base64),
Parts = Json.Document(Base64Url.Decode(Text.Split(Token, "."){1}))
in
Parts
let
Token = "<snip>",
Base64Url.Decode = (s) => Binary.FromText(Text.Replace(Text.Replace(s, "-", "+"), "_", "/") & {"", "", "==", "="}{Number.Mod(Text.Length(s), 4)}, BinaryEncoding.Base64),
Parts = Json.Document(Base64Url.Decode(Text.Split(Token, "."){1}))
in
Parts
@Anonymous
I am not familiar with JWT, see if this post help:
powerbi - Power BI - Get JWT Token from Auth API - Stack Overflow
Paul Zheng _ Community Support Team