Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Powershell runbook PowerBI API connection with managed identity

Hello

Is it possible to connect to powerbi service from a powershell runbook using a managed identity ?
Now I am using a run as account connection.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Please take a look at the following blog to see if it helps, Four things you need to do:

    - Create automation account.

    - Create credential asset.

    - Import needed modules.

    - Setup runbook with script and schedule it.

     

    Integrating PowerShell with PowerBI: Automating in... - Microsoft Power BI Community

     

    Best Regards,
    Community Support Team _ Caitlyn

    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

    Anonymous thank you for your response, but I think the example above doesn't use a managed identity connection.
    I had the idea to create a security group than add the managed identity of ADF than add the security group as an admin of the powerbi workspace.
    Then, I don't know how to connect to powerbi service with a powershell runbook.