Refresh Report with Service Principle

Tdawg90 · ‎06-20-2019

I have a power bi Report on powerbi.com that access Azure Data lakes for it's data. Currently it's running under my own personal credentials but I need to to leverage an Azure Client/App Service Principle.

How can I set up the powerbi refresh leveraging the service principle Id/Secret, or better yet access the keyvault to get the secret when it performs the refresh?

v-frfei-msft · ‎06-20-2019

Hi @Tdawg90 ,

You should change it in Power BI side and republish the report.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Tdawg90 · ‎06-21-2019

Can you elaborate? The end goal is to have the data auto-refresh daily from Azure Data lakes utilizing non-personal credentials, idealy a Service Principle

Bizzle · ‎05-30-2023

Hey did you manage to get this sorted?

I am busy going down the same route - especially since my user account requires a PIM which only lasts 9 hours

Tdawg90 · ‎05-31-2023

This was a while ago with Gen1, today using Azure Data Lakes Gen2, (it should be there for Gen1 and I don't know what was going on back in 2019 😄 ) we can easily use an Access Key to a Azure Blob Storage.

Add the full url to the blob container. It will then prompt you for an Access/Account Key, which you can find in your storage account,