What is best practice for automatically refreshing service princpal PAT in Power BI for a connection to a Databricks dataset? Ideally when the PAT is updated it will automatically be stored in Azure Key Vault, is there a way that Power BI can pick it up automatically from there?
Quick Details of Setup:
- Power BI dashboard published to Power BI Service
- Databricks data source
- Service Principal
- Personal Access Token (PAT) expires every 90 days, so will update every 70 days
- Ideally PAT credential storied in Azure Key Vault for Power BI to access
- How to automatically refresh PAT in Power BI?