Forum Discussion
Using Service Principal for refreshing datasets published in PowerBI Premium Per user workspace
Hi,
Can we use service principal to automate refresh of Tabular models that are deployed to PowerBI Premium Per User workspace?
We plan to use Azure Automation runbook to achieve this.
Regards,
Ashish
6 Replies
Hi, sure you can. You can follow this post to set up some configurations until the data factory section starts
https://blog.ladataweb.com.ar/post/642023841877671936/azuredatafactory-actualizar-powerbi-conThen you can write your runbook in any language to make two requests. One for geting the bearer token and another to post the refresh.
I hope that helps,
What is the error code responding? (I mean number, 400, 403, 404, 500, etc)
It looks like you are not being able to autheticate to get the authorization or bearer token to make the request of refresh.
Remember you need to authenticate first, get the big token and then use that to trigger the refresh. You need the Service Principal configured like the post I have sent.
Regards,
I did speak with MS Support and they confirmed that currently Service Principals are not supported in Premium Per User Workspace.
As a workaround, for the development environment, I created a user credentials within Automation and used that credentials for authentication and refresh of the tabular models that are deployed to PowerBI Premium Per User Workspace.
Regards,
Ashish
