Forum Discussion
Helper IVOne report from many reports
Solution SageFrom your post, it appears that each of the 3 reports are built without an underlying data model (semantic layer). The power of Power BI is "to develop once and use numerous times". If you find yourself creating reports that require merging logic (tables, calculations, joins, etc.) from multiple reports, then it is time to think about developing a semantic layer to feed your reports. See https://www.sqlbi.com/articles/power-bi-is-a-model-based-tool/ more details.
A semantic layer also helps you empower your business users using a governed self-service data architecture.
giuliapiazza94no, i've 3 reports and each report depends from a data set, so they are indipendent reports from each other
- Shahfaisal
My response is still the same.
- If this report that you need to develop is just a one-off request, meaning you don't anticipate more reports in the future that require merging the datasets into a single model, then you can proceed with creating the report focusing just on the report and not too much on the extensibility of the underlying model .
- On the other hand, if you anticipate that users are going to ask for more such reports in the future where you will need to merge the 3 datasets, then I suggest that you take time to develop the data model first and make sure it is scalable and extensible, and then develop the report on top of the data model.