Forum Discussion

robofski's avatar
robofski
Resolver II
8 years ago
Solved

Duplicate report using the same Dataset

I want to create a new version of one of my existing reports (to take advantage of the new filters across report option).   The ways I know to do it all have an issue that I'd like to avoid!   1)...
Need Help
  • robofski's avatar
    robofski
    8 years ago

    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.

burtta's avatar
burtta
Advocate I
3 years ago

When attempting this solution, I received a prompt after selecting the dataset from the Power BI service. Any suggestions?

 

 

  • RichJW's avatar
    RichJW
    Helper III
    3 years ago

    burtta No expert on this, however when connecting to another PBI data source, you need to remove ALL tables. The error you receive suggests you are already connecting to another data source. 

    My advice is if you want an additional data source to the second PBI report, then you need to add it to the original PBI dataset you are pointing the new report towards.