Power BI - Databricks Connection using Service Principal PAT Refresh
- 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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-10-2023 12:30 PM
May be not the recommended way, but try to create a token that do not expire for such use cases. Ideally you will need like a custom powershell type of solution to get it automated completely.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2023 06:57 AM
Thank you for the reply. Unfortunately this does not meet our security requirements
