Forum Discussion
Pass data source credentials in Power BI as parameters
Solution SupplierYou can create custom connector with authentication type as "UsernamePassword"
Here are some links which may help you
Authentication Handling: Handling authentication for Power Query connectors - Power Query | Microsoft Learn
Creating simple custom connector: Create custom connectors in Power Bi - YouTube
Dhairya thanks for the reply.
This is for Azure sql as a data source.
Could you please share any sample power bi file which has these power query connectors implemented.
Please help.
- Dhairya
Here is the official github repo of microsoft here you can find stepwise implementation of custom connectors and there are some connectors present in sample folder
https://github.com/microsoft/DataConnectors
You can refer this one also and modify your connector as per your requirements.
https://www.progress.com/tutorials/odata/connect-to-odata-from-power-bi-using-oauth2-authentication
Hello Dhairya,
I have a similar problem where i need to give the database name,username and password of the sql from powerbi Service.
A test case will be like
I have a dummy data in db1,username as dup1, password as duppass (all users have these creds)
and original data in db1, username as ori1, password as oripass.(only some admin users have these)
Is there a way I can select the database and by giving username and password from the front end powerbi service to which ever data i want to see?
Can anyone help me with this please.
Thanks,
Harsh
