cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

@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

@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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors