Forum Discussion

paocohe's avatar
paocohe
Frequent Visitor
2 years ago

Add manually client id and client secret when using custom connector

Hi again community!

As I mention on my latest post I'm  new to this power bi universe and i've been trying to make a custom connector with oauth to reach an specific end point. Right now I'm able to complete the autenthication process and get the data right, now we want to escalate it...

We want to make it available for several users, so I have a few questions:

1.- is it possible to add client id and client secret from an user interface without making changes on the code? i was wondering if it's possible to add it as we add the url in power bi.

2.- if this is not possible how can i manage this escalation to several users without making them change the code to add their own client id and client secret data? 

 

I appreciate all the help and suggestions. 

Thank you 🙂

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi paocohe ,

    1. Unfortunately, Power BI does not provide a built-in user interface for directly inputting client IDs and client secrets without altering the code. These values are typically stored in configuration files that are part of your application's codebase.

    2. You may consider c    reate parameters in Power BI Desktop that prompt users to enter their own client ID and client secret when connecting to the data source. This way, users can input their credentials directly in Power BI without modifying the connector code.
    You can also pull back all the data first and then set the RLS according to the user.
    Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

    • paocohe's avatar
      paocohe
      Frequent Visitor
      2 years ago

      Thanks for the information.

      I'm wondering if maybe i can achieve the expected result by somehow in the code make a call to a modal for the user to type the credentials, just like I have it right now with the url. Did you know if maybe I can do that?