CD (continuous deployment) best practices for power bi report

Enterprise Deployment
4

Hi Greg:
Finally, viewed the youtube and the blogpost. Currently we are using A-SKU instead of P-SKU. We are leveraging Azure DevOps for our CICD pipelines. I have a couple workarounds to automate this. But not the best.

  1. Leverage parameters to set my DB connection string in PBIX file : ServerName & DatabaseName
  2. save the PBIX with ‘empty’ tables. – create a empty SQL db without any data.
  3. Check PBIX file into Azure DevOps
  4. CD pipelines will
    i) push PBIX file to a pre-defined workspace
    ii) Update Parameters to set DB connection string via Power BI API
    iii) Trigger 1st data refresh via Power BI API

welcome comments/suggestions

Thanks!