Programatically change the Data Source connection of .PBIX file

[Miruthan]

Hi,

We have requirement to replicate same report to multiple client, only we need to change the data source. Is there any way i can programtically change the data source of .pbix file without open the file and automatically publish to Power Bi report server?

Thanks

[dhawal16]

Hi Miruthan,

Did you able to achieve this? We have exactly same need except we want to change SQL DB and not SSAS.

Please let me know.

Cheers,

Dhawal

[Miruthan]

Hi @dhawal,

No, We are not able to achieve, but we need to find the workaroud. Please share your thoughts if you have some.

[v-ljerr-msft]

Hi @Miruthan,

Here is a similar thread in which a possible solution to programtically change the data source of .pbix file without open the file is mentioned. Could you go to check if it helps in your scenario?

As to automatically publish to Power Bi report server, I haven't seen a possible solution currently. 

Regards

[Miruthan]

hi @v-ljerr-msft I dont think the solution will help me, I am connecting SSAS multi dimensional cube,. Is there any way using C# or powershell i can update the connection string.

[v-ljerr-msft]

Hi @Miruthan,

As far as I I know, there're no such ways using  C# or powershell to update the connection string for a pbix file currently. 

Regards