Authentication Scenario Help

[gesgin]

Hi,

The authentication scenario that we think for our users is as below;

The users develop their reports on Power BI Desktop on their local machine. They can connect to our dwh db or analysis services as a source. Is it possible to by-pass the stage that they write the user-password to connect to db? I mean, by LDAP entegration, can we let the application uses the password instead of the developer? I'm asking this because we don't want to share the user-password with everyone.

Thank you

[v-shex-msft · Accepted solution]

HI @gesgin,

>>They can connect to our dwh db or analysis services as a source. Is it possible to by-pass the stage that they write the user-password to connect to db?

Current power bi use windows credentials to get data from analysis services, you not need to input account and password.

Your current Windows credentials are used to connect to the Analysis Services server. You cannot use Basic or stored credentials in either the Power BI service or Power BI Desktop when exploring live.

I'm not so sure which type of data warehouse data source you used, but I don't think you can skip sign in steps.
Maybe you can take a look at below link told about how to set up api server to enable LDAP:

Use the API Server and LDAP ADO.NET Provider in Microsoft Power BI

Reference links:

Using Analysis Services Tabular data in Power BI Desktop

Regards,

Xiaoxin Sheng