Forum Discussion
Anonymous
6 years agoNot applicable
data modelling help needed
Hello experts, need your input in building a PBI data model for ad hoc report where i have 30 dim tables and 2 fact tables. How should i connect them provided most of them have a common primary key i...
amitchandak
6 years agoSuper User
Powerbi suggests having a star schema model. Please refer to the document
https://docs.microsoft.com/en-us/power-bi/guidance/
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin