Currently I am working on a way to automate deployment of Power BI pbix files. An important part of the solution is to set credentials on the data sources. The organization has a Power BI environment with approx. 40.000 connection. The vast majority being Excel and cvs files and 2500 of these connections are SQL Server connections. Company polices require to connect to SQL server (on-prem + cloud) only with AD / AAD credentials (so no Basic authentication, and preferably an SPN) and we are also pushed by security architects to set up automated password rotation.
About 6 month ago, I got to the point I could create with an C# azure function an oAuth2 token, but the validation was only 45-60 minutes. This would result in somewhat unpractical solution to update 2500 connections every 45-60 minutes, so we did not take this approach any further.
My question is of any one already had any succeeded in setting up connections with AD/AAD credentials in way that is practical to use on a large scale with multiple enterprise development teams creating Power BI projects. I already had a look at "https://powerbidevcamp.powerappsportals.com/sessions/session33/", but that stil leaves me with the 60 min limit on tokens
