Power BI - Databricks Connection using Service Principal PAT Refresh
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-10-2023 07:33 AM
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?
