https://community.databricks.com/t5/data-engineering/power-bi-databricks-connection-using-service-principal-pat/m-p/50821#M28904 <P>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?</P><P>Quick Details of Setup:</P><UL><LI>Power BI dashboard published to Power BI Service</LI><LI>Databricks data source</LI><LI>Service Principal</LI><LI>Personal Access Token (PAT) expires every 90 days, so will update every 70 days</LI><LI>Ideally PAT credential storied in Azure Key Vault for Power BI to access</LI><LI>How to automatically refresh PAT in Power BI?</LI></UL> Fri, 10 Nov 2023 15:33:50 GMT js54123875 2023-11-10T15:33:50Z https://community.databricks.com/t5/data-engineering/power-bi-databricks-connection-using-service-principal-pat/m-p/50821#M28904 <P>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?</P><P>Quick Details of Setup:</P><UL><LI>Power BI dashboard published to Power BI Service</LI><LI>Databricks data source</LI><LI>Service Principal</LI><LI>Personal Access Token (PAT) expires every 90 days, so will update every 70 days</LI><LI>Ideally PAT credential storied in Azure Key Vault for Power BI to access</LI><LI>How to automatically refresh PAT in Power BI?</LI></UL> Fri, 10 Nov 2023 15:33:50 GMT https://community.databricks.com/t5/data-engineering/power-bi-databricks-connection-using-service-principal-pat/m-p/50821#M28904 js54123875 2023-11-10T15:33:50Z https://community.databricks.com/t5/data-engineering/power-bi-databricks-connection-using-service-principal-pat/m-p/50838#M28915 <P>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.&nbsp;</P> Fri, 10 Nov 2023 20:30:57 GMT https://community.databricks.com/t5/data-engineering/power-bi-databricks-connection-using-service-principal-pat/m-p/50838#M28915 SSundaram 2023-11-10T20:30:57Z https://community.databricks.com/t5/data-engineering/power-bi-databricks-connection-using-service-principal-pat/m-p/51087#M28959 <P>Thank you for the reply.&nbsp; Unfortunately this does not meet our security requirements</P> Mon, 13 Nov 2023 14:57:14 GMT https://community.databricks.com/t5/data-engineering/power-bi-databricks-connection-using-service-principal-pat/m-p/51087#M28959 js54123875 2023-11-13T14:57:14Z