Automate - Moving reports and data sets between environment , update data source and refresh data

[keerthim]

We are trying to automate to move powerBI reports and datsets between environments(Dev, QA, UAT and production) using powerAPI in powershell script. We tried with the following different ways to implement:

1. Considering each environment as specific workspace. As per powerBI API(https://msdn.microsoft.com/en-us/library/mt147898.aspx ), we can clone reports but we cannot clone dataset .
2. We imported pbix files using powerBI API, then tried to get the datsources , but powerBI API supports only direct query.
3. We considered gateway, but rebinding didn’t work. One of the documentation saying that the server and database name will have to be same to bind to different gateway.

Bit of dead end.

The only way at the moment we have , to change connection details is to unzip the pbix, change some details in a file and zip it up again.

Is this works? Or do you have better solution to this functionality?

Thanks

Keerthi