Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Atish
Frequent Visitor

Remove Duplicate Datasets

Hello,

 

I have a 4 Reports with the same Dataset but different views and filters.

I now understand this is not the correct way but this is what I did.

1. Created one Report and published it

2. Made a copy of the 1st reports and made changes to it and published it again ... 3 times [using the PBI desktop]

 

So now I have the same dataset 4 times. Is that a way I can combine the all of them to 1 without having to recreate 3 reports again using the PBI Service.

 

Any suggestion or ideas on this.

Thanks 

 

1 ACCEPTED SOLUTION
Seth_C_Bauer
Community Champion
Community Champion

@Atish I think you will need to recreate the reports. Although, I wouldn't do that in the Service. I would set it up this way.

1st report - built in Power BI Desktop, publish

2nd report - Connect to the dataset "Power BI Service" connector. Build report in Desktop. Publish -> This will only deploy the report to the workspace. Save the file seperately as Report2

3rd report - same as 2nd

4th report - same as 3rd


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

1 REPLY 1
Seth_C_Bauer
Community Champion
Community Champion

@Atish I think you will need to recreate the reports. Although, I wouldn't do that in the Service. I would set it up this way.

1st report - built in Power BI Desktop, publish

2nd report - Connect to the dataset "Power BI Service" connector. Build report in Desktop. Publish -> This will only deploy the report to the workspace. Save the file seperately as Report2

3rd report - same as 2nd

4th report - same as 3rd


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.