question

ArcherJayden-7162 avatar image
0 Votes"
ArcherJayden-7162 asked ·

Azure APP using Service Principal to Refresh Dataset from Powershell

Hi,
I am trying to automate the process of refreshing dataset of powerBI and integrate that into my SSIS ETL load so that right after data loads, I have my dataset refreshed automatically from powershell script.
I have API created with type server side web app which registers a new APP on Azure AD where I have given both read & write Dataset.ALL permission.
I have added this app to a security group in Azure AD and enabled "Allow Service Principal to access PowerBI API" at Admin settings in PowerBI
I have added the Service Principal Name to PowerBI workspace as admin
Now using the APP ID & APP Secret and tenant ID I am trying to authenticate from Powershell and refresh the dataset however I get an error Unauthorized in Powershell

Please help or guide

Thanks,
--Archer

azure-active-directory
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered ·

I suggest you to please reach out to PowerBI community with your question where you can find community presence specific to PowerBI and they will help you.
Also, check the documentation if you are not missing anything.


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.