Using API to clone report and dataset into new workspace

[bmavity]

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?

[v-jiascu-msft]

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

[bmavity]

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.