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?
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.
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.
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.
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.