I have a few questions. When I bring in a database model like this into PowerBI.
1) How do I convert this most effectively into a star model?
2) If I don’t convert it to a star model, can reports be built on this model?
3) Where can it go wrong, when reporting on a model like this?
Thank's very much.
Solved! Go to Solution.
Thanks very much.
I'm using Directquery. The questions I still have are, how can I get a star schema with only the dimensions and facts, I need from the model above in the fastest way. So without etl tools. Only with SQL queries and PowerBI.
And does this mean that calculations and filtering over multiple tables and complicated relations can't cause wrong answers in your report?
Hi adetogni, Laz,
Thanks very much for the answers. I will just ask the database engineers if they can do the dimensional modeling, since they are the experts at it.
For me as the data-analyst, I will just focus on querying the right tables I need and then import the tables into PowerBI or connect to them in PowerBI.
Then in PowerBI, I can create the relational model and then, make the model as star model as possible.
If I can’t create the dimensional and fact tables I need, then I’ll ask the database engineers if they can help me with the dimensional modeling.
Problem solved 😊. Thanks for helping me find the answer.
And thanks for the book, I will read it.