Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

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....
Need Help
Tips and Tricks
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, Anonymous 

    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's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      v-yueyunzh-msft
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi, Anonymous 

      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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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.