How to connect database using service credential or other identity but not my own credential

[bingo]

I want to embed my powerBI dashboard to power app, but I find that the dashboard connect to the database use my own identity. I think that this maybe not  good, as I am just one developer of the app. Is there any other credential can be set to connect to the database such as Azure managed identity?

Thank you very much for any possible help.

[v-yueyunzh-msft]

Hi, @bingo 

Do you mean you want to edit the credential in Power Bi desktop？

If this .File => Options and Settings => Data Source Settings

Find the data source in question and clear or edit the permissions. It will be in "Global permissions" if the file is not open.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[bingo]

Thanks. I know that connect to database need one credential, and now the credential is got by login my personal account. For one public use dashboard, what I want to know is that can I use other way(other account or azure managed identiity, etc.) to connect to the database.

[v-yueyunzh-msft]

Hi, @bingo 

As I understand it, you want to manage your database's credentials on the Azure side?
If so, then only the Azure database will support it, but the essence is the same as your account password.
If it is not an Azure data source, then all credentials are managed on your data source, and Azure mainly manages the permissions of the Power BI AAD account, and there is no direct essential connection with your data source.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[bingo]

Thanks! I want to connnect to Kusto. Can you share some docs or links. In the powerBI service, only by sign in with one account can I get the credential.

[v-yueyunzh-msft · Accepted solution]

Hi, @bingo 

For Kusto database permissions, you need to click "Sign in" and enter your newly created account to log in.
Whether to support login with the same account and password as SQL Server requires you to confirm with the database.

For more information, you can refer to:

An Introduction to OAuth 2 | DigitalOcean

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[v-yueyunzh-msft]

Hi , @bingo 

According to your need , you want to use the other credential to embed the content in Power BI instead of yours.

I think you can try to use the "Service principle" to embed your content in you Power BI Service.

Service principal is an authentication method that can be used to let an Azure AD application access Power BI service content and APIs.

For more information, you can refer to this :

Embed Power BI content in an embedded analytics application with service principal and an applicatio...

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[bingo]

Thank you. Maybe my descriptiuon is not unclear enough, I mean the credential connect to the database. Now, I need to login in to use my own account and password, so the powerBi can get my credential and then the powerBI can read data from database.

[lbendlin]

Assuming that your Power BI connection only reads data from the DB - you could use a generic read-only db login.  Of course by doing that you lose all auditing details but that may be ok.  Careful about the scope though.

[bingo]

Thank you. you mean that I need one special account(with account number and password) that assign it the previlieges to read data from the database. The account is similiar to my own, but the account is used exclusively to access data and does not belong to any one person.

[v-yueyunzh-msft]

Hi, @bingo 

Yes, you understood it exactly right!It is equivalent to a fixed account to access your database, which requires you to create and give permissions on the database side.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly