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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

how to get value from contents and declare to variable ?

Hello I would like to get value from contens (url) and I would like to use it for oauth2, I cant find the way how can I pass the value from input window and pass it to the OAuth2 flow or put it to the global variable.

I follow the manual https://docs.microsoft.com/en-us/power-query/creatingfirstconnector

from here

pirecko_0-1653295881319.png

 

 

I need my url for my TripPinNavTable and OAuth2 

 

shared TripPin.Contents= Value.ReplaceType(TripPinNavTable, type function (url as text) as any);

 

//OAuth2 values
client_id = "asdfgg98765sad4f35";
redirect_uri = "https://oauth.powerbi.com/views/oauthredirect.html";
token_uri = TripPin.Contents[url]&"/identity/connect/token";
authorize_uri = TripPin.Contents[url]&"/identity/connect/authorize";
logout_uri = "https://login.microsoftonline.com/logout.srf";
client_Secret = "123456789asdf";

 

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @Anonymous 

 

Well this is beyond my knowledge. The resources I found online are all specifying a fixed url in the OAuth2 code. As users may enter different URLs in the connector, will it be possible that the token_uri and authorize_uri have different suffixes for different URLs?

 

Best Regards,
Community Support Team _ Jing

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.