Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am new to PowerBI and want to copy/clone an existing report to new one with new dataset.
Here is what I am trying:
I have attempted following approaches:
However, with both of above, the report or its visualisations are not populated. It is showing error as
Something's wrong with one or more fields
Here is how the cloned report looks:
I have been struggling with this since couple of days.
Thanks for help in adv.
PS :
I don't know which location I should tag this query. Selected 'Service' for now. Please let me know if anyone knows where this query belongs to.
Updates:>>>
To update further on this, here is what I experimented. (Lets call original report as 'report-A' created by uploading .pbix file)
Here, the dataset are identical in true sense, but issue still persists. Any thoughts on how I can retain the visualisation configuration during report clone or rebind?
Hi @piper ,
Are you using this API?
This API seems to copy the report from my workspace to the application workspace.
Do you want to merge two reports? If yes, you can create dashboards.
Or can Power BI report templates help you?
Create report templates for Power BI Desktop
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your response.
Yes, I was using the following api :
However, while cloning with new dataset, it doesn't populate the report correctly.
Currently, I don't want to merge reports.
I am new to Power BI, not sure if we can clone the templates via REST api. Need to investigate in that part.
I will go through your shared link and will see if it serves our purpose.
It is just that, I want to automate all these for new clients/customers w/o manual intervention, atleast for existing reports.
Hi @piper ,
Has your problem been solved?
Did you fill in the API parameters correctly?
You can refer to this video.
https://www.youtube.com/watch?v=fXbJeIY2CgE
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your response.
Later, I got it working by following the approach mentioned here : https://stackoverflow.com/a/62150816/2152016
Well the most obvious question here, are the two datasets identical in terms of their table and column names?
Good point.
I think both the datasets are identical, as I have used same csv file to create existing and new dataset. However, not sure, if power bi does some internal manipulations for uploaded csv or not.
To further update on this, here is what I experimented. (Lets call original report as 'report-A')
Here, the dataset are identical in true sense, but still issue persists. Any thoughts on how I can retain the visualization configuration during report clone or rebind?