topic Using API to clone report and dataset into new workspace in Developer

Using API to clone report and dataset into new workspace

bmavity — Mon, 13 Aug 2018 19:38:10 GMT

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:

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.
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?

Re: Using API to clone report and dataset into new workspace

v-jiascu-msft — Tue, 14 Aug 2018 09:47:13 GMT

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

Re: Using API to clone report and dataset into new workspace

bmavity — Tue, 14 Aug 2018 12:47:17 GMT

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.