Forum Discussion
How to split a report and change the dataset?
- 7 years ago
Thanks mussaenda,
thats waht I was searching for. Could not imagine, that it is so easy.
1) I saved the original report as "Base"-Dataset
2) I created a new Report, using the "Base"-Dataset as (only) source
3) I copied everything with STRG+A -> STRG+V (page by page)
4) I had to re-set the report/page level-filters (but thats everything, formating and visual filters are copied)
5) I saved the file es "Individual1"-Report
6) I did the steps 2-5 for all pages/reports, I want to move
7) I deleted the reports in the "Base"-Dataset (which now contains only the connections and the row-level-security)
Many thanks, for your help. I still could not "exchange" the dataset, but is is so less work, that it is easy to handle (needed just once).
Best regards,
Thomas
I have created a powershell script that creates a new PBIX file with just the reports in it. I have found it a lot easier than to do this whole process manually. https://github.com/rajrao/mypublicnotes/blob/master/PowerBi/ConvertDatasetPbixToReportsOnly.ps1