topic Re: Using SPN with PowerBI dataset in Powershell in Developer

Using SPN with PowerBI dataset in Powershell

Anonymous — Thu, 21 Jan 2021 19:11:40 GMT

We have created a CI/CD pipeline for our PowerBI reports. Uploading, taking over the datasets, changing the datasource. But we can not update the credentials for the SPN that is now set as Owner of" the dataset. So after the release we need to go in and take over the dataset and use our own user to confirm credetinals. Is there someone that can help us using spn as dataset owner. We use powershell to change datasources and takeover.

Re: Using SPN with PowerBI dataset in Powershell

lbendlin — Fri, 22 Jan 2021 18:19:17 GMT

I don't think a SPN can own a dataset. Do you have any documentation that says otherwise?

Re: Using SPN with PowerBI dataset in Powershell

V-lianl-msft — Wed, 27 Jan 2021 05:54:03 GMT

Hi @Anonymous ,

See if it will help:

https://medium.com/riccardo-perico/spn-azure-runbook-webhook-power-bi-refresh-pt-1-307e7c8637f3

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