Pass data source credentials in Power BI as parameters

[Anonymous]

Hello All,

I would like to know that, Is it possible to use parameters to update the data source credentials in power bi service and and authenticate.

The reason behind this question is, I have published 15 reports to Power BI Service workspace.

These 15 reports are part of a client lets call it as CLIENT1 and the ServerName as SERVER1, database used for all these reports are DATABASE1 with UserName ABC and Password as ABC123. 

For CLIENT2 also we need to have the same template reports in another workspace as WORKSPACE_CLIENT2.

But the Server, DB and credentials are as SERVER2, DATABASE2 with UserName DEF and Password as DEF123.

**The schema between these servers and database tables used for the reports are same.

I have created parameters in power bi desktop as paramServer, paramDB and our devops team were able to update the details through REST API.

I understand that the data source credentials authentication is something not possible for so and so secirity reasons using REST API.

https://community.powerbi.com/t5/Developer/Power-BI-REST-API-Update-datasource-credentials/m-p/11986...

https://ideas.powerbi.com/ideas/idea/?ideaid=a08d1dd1-6be8-47ab-a95b-c0a020d71417

But I would like to know, if is there any possibility to have the parameters for UserName and Password for datasorce in power bi desktop, do update and authenticate in power bi service through programatically but not manually.

Any suggestions please.

Thanks,

Mohan V.

[Dhairya]

You 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

[harsh_09]

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

PREVIEW

[Anonymous]

@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