Multiple reports from a single dataset in desktop

Thanks DataInsights 🙂

Here's a view of the current architecture;

The BI reports are connecting to the Ops Mart, but are too constrained for my purposes, e.g. cannot connect to additional sources, write custom queries or DAX, hence why the Analysis reports have been set up.

The trouble is, the SQL queries against the mart all sit in these reports, meaning any changes have to be replicated to each individual report.

It sounds like the Golden Dataset approach is what might work for us but where is this built; in PBI itself or elsewhere?

Just to check my understanding here; as new composite elements are built from the mart, this could be done using SQL queries in the Golden Dataset.  As long as these changes do not affect the existing structure and content of the tables, the new elements would simply appear in the downstream reports - is that right?  I'm a little concerned that any DAX or M queries in the downstream reports might 'break' if the Golden Dataset changes key components in these.  (hopefully that makes sense in my noddy language!  lol)

Edit: Just found this resource, which seems to explain it really well. https://exceleratorbi.com.au/new-power-bi-reports-golden-dataset/

N.B. I've changed from DirectQuery to Import, which has opened up the full use of DAX and seems to be working fine.

Thanks again for your continued assistance with this. It's very much appreciated. 🙂