Forum Discussion

cerebraino's avatar
cerebraino
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

Fat and Slow Golden Dataset Situation How Could Dataflows and Datamarts Help?

Hello, at work we use a "golden" dataset containing all tables and measures, management does not want Power Bi developers like me creating stand-alone datasets and measures because in the past that h...
dataflow
Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    3 years ago

    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.

Tutu_in_YYC's avatar
Tutu_in_YYC
Icon for Super User rankSuper User
3 years ago

Im having the same challenge with a client's golden dataset. Our case is we cant "remodel" the dataset to answer new questions and requirements, so we ended up with DAX calculations that are complex and time consuming.. The idea of Golden dataset is great, but it has it's challenges, especially if you want to create a optimized data model for fast report.

 

I dont have any input on your challenges, but one thing that you can try if you want to improve "development-waiting-time" is to use the ALM toolkit to perform data model updates eg. addding measures etc. Just be aware that its still limited.