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.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.