Forum Discussion

boble's avatar
boble
New Member
2 years ago
Solved

Managed indentity and Power BI

Hello,   We aim to ensure our reports are not user-dependent. That's why we're interested in using a managed identity to manage the connections to our data sources. However, we're struggling to fin...
Data Protection
  • tackytechtom's avatar
    tackytechtom
    2 years ago

    Hi boble ,

     

    The idea is to refresh the token right before a semantic model refresh is triggered from the refreshes REST API.  It's almost like a Just-In-Time access control approach: Anytime you want to fetch data from your sources, grab an access token from Entra ID (former Azure Active Directory) and use it for authentication. Then trigger a semantic model refresh via the REST API to get the data into Power BI. If you are already using the refreshes API to trigger a refresh (from a Data Factory, PowerShell, Python Script etc.) you would just need to add that part of fetching a token and updating the semantic model credentials before.

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

boble's avatar
boble
New Member
2 years ago

Hi,

 

Thank you for the link. It was very informative. I see at the end of the article that there is an issue with the token expiration. How did you solve this?

tackytechtom's avatar
tackytechtom
Most Valuable Professional
2 years ago

Hi boble ,

 

The idea is to refresh the token right before a semantic model refresh is triggered from the refreshes REST API.  It's almost like a Just-In-Time access control approach: Anytime you want to fetch data from your sources, grab an access token from Entra ID (former Azure Active Directory) and use it for authentication. Then trigger a semantic model refresh via the REST API to get the data into Power BI. If you are already using the refreshes API to trigger a refresh (from a Data Factory, PowerShell, Python Script etc.) you would just need to add that part of fetching a token and updating the semantic model credentials before.

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/