Forum Discussion
Microsoft EmployeeFat and Slow Golden Dataset Situation How Could Dataflows and Datamarts Help?
For sure! Another client is doing intense chaining with mixed storage model, i.e direct query an existing dataset (golden dataset) and add additional table using other data sources. It is more complex as they propragate.
Microsoft EmployeeHi Tutu thsnks for yoru answer and recommendation to use ALM toolkit, actually I am using Tabular editor for making changes in the model and have to update just once instead of each time, I will take a look at ALM toolkit.
I totally relate to your comment about fat / innefficient / wrongly structured data model leading to complex DAX, in my case I would oike to add the fragile "house of cards" situation, often old reports stop working because slight changes in the data model, for instance two tables actually connected several times indirectly trough other tables, rendering the model unstable and often unpredictable.
Seems we share similar challenges maybe we could remain in touch sharing different solution/improvement approaches. Thanks again!
Juan
Super UserFor sure! Another client is doing intense chaining with mixed storage model, i.e direct query an existing dataset (golden dataset) and add additional table using other data sources. It is more complex as they propragate.