- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- 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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 11-19-2019 08:31 AM | ||
07-03-2024 12:12 PM | |||
01-18-2022 12:30 PM | |||
10-24-2023 04:06 PM | |||
02-13-2024 07:59 AM |
User | Count |
---|---|
6 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
11 | |
3 | |
2 | |
2 | |
2 |