Reply
bmavity
Frequent Visitor

Using API to clone report and dataset into new workspace

I'm working on creating an automated process to create a new report/dataset from a template using Microsoft Flow and the Power BI API.  Using Flow limits me quite a bit, but I believe this should be plausible.

 

A couple options and my limitations are:

  1. Import from .pbix file to destination workspace, then update report parameters (Post Import in Group)
    • I'm unaware of any way to convert the .pbix file in Flow and passing to the request body.  Is this a viable option?  The only solutions I've found use scripting languages that aren't a current option.
  2. Copy Report from Template workspace to destination workspace (Clone Report in Group)
    • I'm stuck here not having a datatset to tie this to (targetModelId parameter).  Is there a way to duplicate a dataset from another workspace (or another source) prior to cloning report?  I don't need the data, but just need the scheme, so maybe there's a way to extract that instead?

Are there any other options that could fit this Flow-API model?

2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @bmavity,

 

1. I would suggest you go to https://flow.microsoft.com/en-us/support/ for professional support.

2. How about exporting the report and then importing it?

 

Best Regards,

Dale

 

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks, Dale!  Appreciate the reply.

 

I have submitted a support ticket with Microsoft as well.

 

As for export then import, I'm consistently getting bad request errors because the export output does not appear to be in the correct format for the import.  I'll keep troubleshooting in the meantime and reply back if there's any significant update.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)