Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Data source credentials, Database and service id

Hi I have setup a service id to login into app.powerbi.com.  When I use it to take over a dataset it requires me to reenter data source creditials. 
When using the desktop I used a database id and password to access the data and it works in the desktop.
In the service I do not see how I can enter this database id/password.
I can not use the service id under auth2 as it fails.

What can I do?

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    If you use a Standard Gateway, please try to create a datasource for database with the same authentication type in Power BI Desktop.

    For more details, you can read related document: Manage a SQL Server data source - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    If you use a Standard Gateway, please try to create a datasource for database with the same authentication type in Power BI Desktop.

    For more details, you can read related document: Manage a SQL Server data source - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.