Forum Discussion
Kudo KingpinMerging PowerBI Files
Can I mrege PowerBI Files? For example, we have 3 different people working to create a dashboard in PowerBI. Can each of us create a component in separate files and then merge the 3 files?
Depends on what you mean by "merge". Each of you are essentially creating reports from a data source in PBIX files. You can upload all 3 files, and the corresponding reports - and there will be 3 different datasets/reports. But you can combine all those reports by pinning visuals from each of the 3 reports to the same dashboard. (thus, "Merging" the reports)
If that's not what you have in mind, can you clarify a bit more?
5 Replies
Depends on what you mean by "merge". Each of you are essentially creating reports from a data source in PBIX files. You can upload all 3 files, and the corresponding reports - and there will be 3 different datasets/reports. But you can combine all those reports by pinning visuals from each of the 3 reports to the same dashboard. (thus, "Merging" the reports)
If that's not what you have in mind, can you clarify a bit more?
BKnechtHi Eno, thanks for getting back to me so quickly.
That does make snese, but the only problem is that, if I pin visuals from each of the reports into one dashboard, and then want to drill down into the visualizations, it will take me to the report for that specific visualization (instead of just one report). Basically, all 3 of us will be working on building different visualizations that all involve the same set of data. Once each of us is done, we would like to merge all of our work into one report.
So, I guess the real question is, can I merge the 3 reports that each of us create into one report, so that when someone drills into any of the visualizations, it takes them to one report?
Thanks again for your input.
I was told that drill into functionality does not work in a dashboard only in reports. How are you getting drill into functionality to work in dashboards. I am creating the reports with drill into functionality and then pinning the reports to a dashboards. The dashboards with pinned reports have lost the drill into functionality.
- ashishrj
Power Participant
BKnecht Another option would be to create a dataset and share it using content packs so that every individual can create theie own set of report and pin visualization to dashboard and later publish again to reflect the updated dashboard.
Even groups have a very good feature of sharing dashboard to users outside group. Group will help users work on single set of dataset/reports/dashboards
