Clone Power BI reports between tenants using Power BI REST API

[TalIL87]

Hi!

I have 2 workspaces:

• Workspace A hosted on tenant A: Vendor workspace which contains the product PBIX. "Golden workspace".
• Workspace B: Client workspace, hosted on tenants B, client workspace.

On workspace A I have: Dataset + report A Report which is connected to the dataset above.

I want to copy the content workspace A to workspace B using the rest API. (I am using python).

I am using PPU or Pro license, I don't have premium capacity.

I want to copy the content workspace A to workspace B using the rest API. (I am using python). I am pretty familiar with Power BI service principal profiles and used them several times.

a legit solution can be to import PBIX files to workspace B, I don't must clone workspace A.

My final goal is to create the workflow on this link.

Thank you, Tal

[Hariharan_R]

Hi @TalIL87 

You need to ensure you are using the right authentication.

Ref - https://www.sqlshack.com/migrate-power-bi-reports-between-multiple-workspaces/

Ref - https://powerbi.microsoft.com/sv-se/blog/duplicate-workspaces-using-the-power-bi-rest-apis-a-step-by...

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[TalIL87]

Hi

I generated the token and used in order to create workspaces an dusers. So from the authentication aspect I think I am good. Thanks for the links, the thing is that all the examples are based on powershell. any chance you have examples with the REST API HTTP requests?

appriciate the help, Tal

[Anonymous]

Hi @TalIL87,

Did these report contents design on the power bi service side? If not, I'd like to suggest you parametrized these reports with query parameters.

Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power B...
Then you can directly use rest API to export and re-publish to different tenants, and change the query parameter to work in different environments.

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev  

Regards,

Xiaoxin Sheng

[TalIL87]

Thanks for the help

I'm familiar with the parameters. Currently, my main obstacle is to import the PBIX or clone it.

I think about 2 options:

1. Clone a work space and all the reports and datasets in it (The option I described above).
2. Import a PBIX I uploaded to Blob storage (The PBIX are small, about 100MB). Does it possible using PPU or Pro license? Or I need premium capacity for this.