How to create a single transformed dataset, which feeds into multiple reports

[cmck]

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, currently this transformation is done separately in every report.

Is there a way through Power BI (or outside of it) that I can complete this data transformation and feed in a single source of data into each of my separate reports?

This is important as things are often tweaked in this data transformation, so doing it once instead of multiple times will save time and reduce scope for error.

Thank you in advance for any suggestions.

[christinepayton]

Yes, 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