Forum Discussion
Data modelling, SQL JOIN vs. Power Query join
Hi, I wonder what is the best practice when it comes to querying for data into a data model. There are times that we can use SQL JOIN to pull data directly into Power Query, but also we can achieve ...
Fact and lookup is normally the best way to go. The narrower your tables are the better (faster calculation) so flattening them by merging is not advised for Fact Tables
Lookup tables however should be flattened to result in a Star Schema. This again has better performance and is easier to use than a snowflake schema
Thank you Wyn.