Data source credentials, Database and service id

[FPP]

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?

[v-binbinyu-msft · Accepted solution]

Hi @FPP ,

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.