Forum Discussion
How to create a single transformed dataset, which feeds into multiple reports
Hi, I have several reports which need to connect to multiple data sources. In every report, the data is transformed in the same way resulting in the same common dataset between them. However, cur...
christinepayton
Most Valuable Professional
Most Valuable ProfessionalYes, this is the recommended way to use the product - having multiple reports use the same dataset. When you create your report, you just choose the source as a Power BI dataset instead of your other upstream source. You'd publish a "golden" dataset you want to use for all of your reports, typically more cleaned up and organized, and potentially certify or promote it in the service.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-discover-across-workspaces