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.
Check out the News & Announcements to learn more.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
Mark your calendars and join us for our next Power BI Dev Camp!
Check out our new Discover Your Career Path blog post series and get all the details.