Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Decode JWT token in custom connector

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 

@artemus 

1 ACCEPTED SOLUTION
curth
Power BI Team
Power BI Team

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

View solution in original post

2 REPLIES 2
curth
Power BI Team
Power BI Team

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
V-pazhen-msft
Community Support
Community Support

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors