Solved: Remove Duplicate Datasets

Atish · ‎06-27-2017

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

Anonymous · ‎06-27-2017

@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

View solution in original post

Anonymous · ‎06-27-2017

@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