I have a Fabric warehouse and a Semantic model developed using Tabular Editor. We deploy the model to a Power BI Premium workspace using Azure DevOps release pipelines, specifically the 'Tabular Database Deployment' job, and a PowerShell script to refresh credentials for different environment releases. Since Fabric warehouse does not support SQL authentication, I had to use Cloud connections and create mapping connections. The data processing works without issues, but there are two features lacking with this Cloud connection: Cloud Connection—'Maps to:' Drop Down: The drop-down does not allow selection of other created connections. If I delete the model and deploy it afresh, I cannot select the earlier cloud connection. I have to delete the previous connection and create a new one. Otherwise, there will be duplicate connections with different names and orphans. The drop-down should allow a selection of available connections. Automating Cloud Connection Mapping: The cloud connection mapping has to be done manually the first time from the workspace. How can I achieve this through PowerShell in Azure DevOps to deploy and redeploy (if it does not exist) every time I release for different environments with different service principals? Can a PowerShell script to create/update cloud connections be shared?
... View more
Is there a reason that your PowerBI cannot point directly to the Analytics endpoint? What is the use case for pointing to the SQL database instead of the analytics endpoint?