Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm very new to Power BI ^^" and i need your advice,
One of my clients requests to create Power BI reports but wants us to only use a view that will contain all of the data that we will use in the report. He strictly doesn't want to use the tables directly and make the connections (in a star) in power bi. Do you think this is judicious? Why are people talking about using models in Power BI (exp: star o) if we can just create one view that contains all data ?
Thank u,
Solved! Go to Solution.
Hi @aminaKh ,
In my opinion, the star schema model still has highly performance in this case as you said even it comes from SQL server. If we just use only one table, when we need to create some measures or use formulas, it could be complicated. In stead of star schema model, the relationship between tables are clearly so that we can transfer them easily.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @aminaKh ,
I think this is judicious and we recomend to create star scema model in power bi desktop.
Do not bring everything into one large table with hundreds of columns:
Star schema is a mature modeling approach widely adopted by relational data warehouses. It is the best way of designing a data model for reporting, You will get the best performance and also flexibility using such a model.
Also, the following articles may help you to understand greater:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yingjl
Thank u for your reply,
When I talk about view, its a view object on SQL server that we will bring on power BI, so basically we will not need to combine data on PBI, so in this case, the star schema can be more performance?
Thanks
Hi @aminaKh ,
In my opinion, the star schema model still has highly performance in this case as you said even it comes from SQL server. If we just use only one table, when we need to create some measures or use formulas, it could be complicated. In stead of star schema model, the relationship between tables are clearly so that we can transfer them easily.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
You can use a single table/view. But for many formula's star schemas is ideal and recommended
Refer recommendations from Microsoft
https://docs.microsoft.com/en-us/power-bi/guidance/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |