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