Forum Discussion
SQL View vs Star Schema Model
Power BI newbie here with a hypothetical question. If, instead of building out a star schema model within Power BI, I created a single view in SQL Server that joined the fact and dimensions in the u...
Anonymous- yes that is fair to say.
Power BI/Tabular models can't see how your database behind the view is structures - it only see the table(s) you add to the model.
Thanks, sdjensen! So, if I'm reading the article correctly, even if my hypothetical view really was modeled as a star schema "behind the scenes," because it's brought into Power BI as a single table, DAX would potentially have issues interpreting the data in the way I expected. Is that fair to say?
Thanks again! This is really helpful information.
sdjensen
Solution Sage
Solution SageAnonymous- yes that is fair to say.
Power BI/Tabular models can't see how your database behind the view is structures - it only see the table(s) you add to the model.