Configure connection string for datasource in Power Bi Reports from Azure Devops

[haddi]

I have a deployment pipeline in azure devops where I can configure the connection string in the appsettings of my webapp for my development and production environment . I have used powerBi embed to integrate Power Bi Reports in my webapp. Is there a way to set what is the datasource for my reports based on the value in my appsettings file which is set in my deployment pipeline.

If I have the connection string variable refer to my development database, then the reports should also use development database as their datasource.

[v-yanjiang-msft]

Hi @haddi ,

Please see if this document helps: Change data source connection strings with PowerShell - Power BI | Microsoft Docs

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.