Changing Data Source in Power BI dynamically using REST API through PowerShell

[Mann]

Hi All,

I have created Power BI report in top of Azure analysis services. Dashboards are also created further on this report. For deployment of these components from QA workspace to Prod workspace, I am using REST API and PowerShell to copy all components from QA Workface to Prod Workface.

In this process I need to do one step manually that is to change the data source to prod AAS model. Can we do this with PowerShell using Power BI REST API.

[v-cherch-msft]

Hi @Mann

I would suggest you visit PowerShell forum for better assistance.Here is the blog about Working with PowerShell in Power BI. 

Regards,

Cherie

[Mann]

Hi,

Thanks for the reply! I posted this on the other forum you recommended. Seems like they have moved it to some other forum.

If we can't alter the data source connection for Power BI live report can we change the connection locally. I mean if I zip the file and change the connection details in "Connection" file within it. I tried this but it says report is corrupted.

If we can do this by some way then I am thinking of automating these steps in Power Shell. Let me know if this can be done?