Forum Discussion
Multiple reports using single Power BI Desktop file
Hi All,
In Power BI Service we can create multiple reports using single dataset/data connection.
All reports are tied to only one dataset.
How to achieve same using Power BI Desktop ? can we create multiple reports using one dataset/data connection in single PBIX file ?
One way could be creating single report in PBIX and publish it , then use same dataset connection for new reports but in Power BI Service.But in this way I will not be able to utilize more features available in Power BI Desktop.
Thanks, Nilesh
5 Replies
The majority of my reports come from a single source file. I simply create multiple pages within that report and pull them apart on powerbi.com and save them as separate reports. My source file has about 30 pages but the reports average about 5 each. Many reuse the same page but have changes saved from the app.
To add more calculations I simply replace the source file prior to an update.
Yes, it is possible for you to create multiple reports connect to one dataset in Power BI Desktop. The very first thing for you is to connect to Data in Power BI desktop, then you can connect to the same dataset when you work with different reports in Power BI Desktop.
I don't think the moderator understood the question. The answer did not help at all.
How do you 'pull them apart'? I have my PBIX source file with multiple pages in there. I would like to splitthem apart when I publish the file to my workspace.
Great question. One thing that I have been thinking about, and doing some testing, is something along this scenario. Have you used the Dashboard yet? When you publish a report to app.PowerBI.com, you can Pin objects to a dashboard. The first time, you create the Dashboard. When you go to publish the next report, you can pin objects to a dahsboard, and you can choose which dashboard. Try pinning multiple objects from multiple reports to the same dashboard. The objects are not live, but this might get you what you are looking for.
Nate
