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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
AakashMarasini
Frequent Visitor

Power Query Custom Connector

Hello Developers,
I am trying to develop the custom connector using M Language with the implementation of oAuth2.0 authentication.
Previously, clientId and clientSecret was accessed from the respective file as:

 

 

client_id = Text.FromBinary(Extension.Contents("Client_ID.txt"));
client_secret = Text.FromBinary(Extension.Contents("Client_Secret.txt"));

 

Now, I am facing trouble to implement the new scenario where user must need to enter the clientId and clientSecret in the parameter to have authentication rather than reading from the respective files.

 

I have developed the simple parameter UI.

 

Testing_Type=type function(

   client_id as (type text meta[
   DataSource.Path=false,
  Documentation.FieldCaption ="Client_id"

]),
   client_secret as (type text meta[
   DataSource.Path=false,
   Documentation.FieldCaption ="Client_Secret"
])

) as table meta[
        Documentation.Name = Extension.LoadString("DataSourceLabel")
];

 

 

AakashMarasini_0-1702019640199.png

How to read those values entered by user?


Thank You!
 #powerQuery #CustomConnector #powerbi

1 REPLY 1
lbendlin
Super User
Super User

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.