topic Re: clone dataset and report between tenants using Power BI REST API in Developer

Clone Power BI reports between tenants using Power BI REST API

Anonymous — Thu, 04 Aug 2022 17:45:11 GMT

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

Re: clone dataset and report between tenants using Power BI REST API

Hariharan_R — Thu, 04 Aug 2022 05:49:00 GMT

Hi @Anonymous

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-step-tutorial/

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

Re: clone dataset and report between tenants using Power BI REST API

Anonymous — Thu, 04 Aug 2022 09:35:56 GMT

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

Re: clone dataset and report between tenants using Power BI REST API

Anonymous — Tue, 09 Aug 2022 02:42:01 GMT

Hi @Anonymous,

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 BI
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

Re: clone dataset and report between tenants using Power BI REST API

Anonymous — Tue, 09 Aug 2022 06:20:13 GMT

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:

Clone a work space and all the reports and datasets in it (The option I described above).
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.