Forum Discussion
Creating Multiple sub report Reports from the same Report
- 6 years ago
You might look into the (relatively) new "what if" parameters, which can be changed by the user but are stored as part of the model.
https://medium.com/dm-p/dynamic-filtering-with-power-bi-what-if-parameters-43ab4953de68
You could also look into shared datasets (if you're using the service)https://docs.microsoft.com/en-us/power-bi/desktop-report-lifecycle-datasets
You can also do all the data modeling in one power bi file and then use that as a datasource for different report front ends. You can share a source file by using OneDrive
https://docs.microsoft.com/en-us/power-bi/service-desktop-files
You might also be able to use a power bi template
https://docs.microsoft.com/en-us/power-bi/desktop-templates
As you can see, there is not a standard way to "develop in one file" and then distribute variations on that file.
You might look into the (relatively) new "what if" parameters, which can be changed by the user but are stored as part of the model.
https://medium.com/dm-p/dynamic-filtering-with-power-bi-what-if-parameters-43ab4953de68
You could also look into shared datasets (if you're using the service)
https://docs.microsoft.com/en-us/power-bi/desktop-report-lifecycle-datasets
You can also do all the data modeling in one power bi file and then use that as a datasource for different report front ends. You can share a source file by using OneDrive
https://docs.microsoft.com/en-us/power-bi/service-desktop-files
You might also be able to use a power bi template
https://docs.microsoft.com/en-us/power-bi/desktop-templates
As you can see, there is not a standard way to "develop in one file" and then distribute variations on that file.
Hi kentyler kentyler. Thanks for your suggestions. As you say, there seems no easy / quick way to do what I wanted. I followed your suggestion to use the master file as the data source. I created a new file, picked my master file as the data source and copied the visuals that I need from the master file (CTRL+A to select all visuals on a page, so I fairly quickly replicated the tabs that I needed on the new report – probably not the neatest solution but an interim quick fix). I am hoping this new file will update when I update the master file without having to “publish” it again. Will explore Row Level Security in the future – sounds like a mega project right now as I am fairly new to Power BI