Forum Discussion

gesgin's avatar
gesgin
Helper I
8 years ago
Solved

Authentication Scenario Help

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

  • Anonymous's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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