Forum Discussion

RonSon2015's avatar
RonSon2015
Frequent Visitor
5 years ago

Data model design - how to avoid calculated column as composite key

Hello all, In order to improve the performance of my data model in SSAS I would like to ask for your tips and tricks how solve the following issues. Light example I've got a fact table and thr...
Need Help
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
5 years ago

Hi RonSon2015 ,

 

Without seeing an example of the actual data in your tables it's difficult to give a definite answer. However, the first thing I would do would be to try and build your third table in Power Query instead.

It appears as though you have common fields that you are using due to being able to utilise RELATED, so you should be able to create this table using merge in PQ.

This may give you the performance gains you want on an overall source -> enduser basis. Even if it doesn't, at least the processing time will be borne by your gateway during data refresh, rather than by the enduser at runtime.

 

Pete