I think that’s a fair statement, though I would just simplify it by saying “try to avoid snowflake models if possible”, with the operative word being “try”. In general, with a plain-vanilla star schema (single level dimension tables with a one-to-many relationship to the fact table(s)), your DAX will be easier to write, validate, debug and understand, and the performance of your report will be better. That being said, Power BI can definitely handle a properly constructed snowflake schema, and there are times when that will be the best structure for a particular use case. But I’ve heard Marco Russo lecture on this topic, and he estimates that 95%+ of reports can be handled best with a star schema.
Here’s a thread on this topic that is worth reading through, as Enterprise DNA experts @Heather and @Nick_M each raise some interesting points that I think you’ll find very relevant.
I’ve really enjoyed working with you on this one, and glad to hear you’ve had a good first experience on the forum. It is a wonderful community.
– Brian