Forum Discussion
Best Practices for Common Data Models
Hi AlexisOlson,
1) Dataset can be stored in one Power BI workbook and multiple Report-only Power BI workbooks can connect to the Dataset Power BI workbook using "live connection" option
See the post below for more details.
https://www.sqlchick.com/entries/2017/5/20/reusing-datasets-imported-to-the-power-bi-service
2) Microsoft whitepaper "Planning a Power BI Enterprise Deployment" also talks the design problem you highlighted. The below is what is said in it.
URL:
https://go.microsoft.com/fwlink/?linkid=2057861
[QUOTE]
Therefore, it is important to separate the development of the datasets used by reports from the reports themselves wherever possible.
This can be achieved in two ways:
| Use of Analysis Services The first option is to utilize SQL Server Analysis Services to store your data. The pros and cons of this approach are discussed extensively in Section 6 of this whitepaper. | |
| .pbix file with dataset only The second option is to create a dataset in a .pbix file without any reports in that file. This .pbix file can then be published to Power BI, creating a new dataset in the Power BI service, and then users can create new reports in Power BI Desktop that connect to the published dataset. This creates what is called a Power BI Live Connection, and behaves in a very similar way to creating a live connection to Analysis Services – without, of course, the need for a separate server – and is more suitable for smaller workgroups. Alternatively, reports can be created directly in the Power BI Service using the web interface.
[UNQUOTE] |
SuraMan Thanks for the link to the paper.
