Using SPN with PowerBI dataset in Powershell

[LarsChrEliassen]

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. 

[V-lianl-msft]

Hi @LarsChrEliassen ,

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.

[lbendlin]

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