topic Add manually client id and client secret when using custom connector in Developer

Add manually client id and client secret when using custom connector

paocohe — Thu, 15 Feb 2024 19:10:07 GMT

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 🙂

Re: Add manually client id and client secret when using custom connector

Anonymous — Fri, 16 Feb 2024 07:21:08 GMT

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 create 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

Re: Add manually client id and client secret when using custom connector

paocohe — Mon, 19 Feb 2024 16:57:31 GMT

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?