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 PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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