Forum Discussion
Duplicate report using the same Dataset
Templates wouldn't be the solution for me as when the template report gets published to the service the data would go with it and then require refreshing.
I did however find a solution so I'm posting it here in case anyone else has the same need.
Created a copy of the Power BI file giving it the name of the new report, so now I have a duplicate with all my data and visuals.
Deleted all the tables and queries from the report. All the visuals still there but obviously all broken now as there's no data.
Get data from the BI Service and select the same dataset the report was originally based on and hey presto all the visuals work again.
Now when I publish to the service it's only a report and will stay connected to the original dataset so no duplicate data to refresh.
Templates wouldn't be the solution for me as when the template report gets published to the service the data would go with it and then require refreshing.
I did however find a solution so I'm posting it here in case anyone else has the same need.
Created a copy of the Power BI file giving it the name of the new report, so now I have a duplicate with all my data and visuals.
Deleted all the tables and queries from the report. All the visuals still there but obviously all broken now as there's no data.
Get data from the BI Service and select the same dataset the report was originally based on and hey presto all the visuals work again.
Now when I publish to the service it's only a report and will stay connected to the original dataset so no duplicate data to refresh.
I know this is almost 4 years old, but this was extremely helpful. I can now refresh over 30 reports in a single step.