The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

Power BI Use Relationship vs Normalization

Power BI Use Relationship vs Normalization


Hi guys –
I understand the instructor to say that it is a better “best practice” to use USERELATIONSHIP vs normalize the tables.  Does anyone have thoughts on this?  (if anyone has architecture experience, maybe you could weigh in)
I feel like your options are  1) UseRelationship   2) Mormalize the data yourself IN power Query editor  3) get the business organization to align and change the data sources themselves before bringing this information together – of course this is the most time consuming part so in the interim of this
Would it be better to userelationship or normalize the data sources using the modeling use and power query editor?  This answer might depend on the amount of data and sources and business operations, but would love anyone’s educated feedback.  Thanks!  

1 Answer

365 Team

Hi Christina,
I would go for USERELATIONSHIP, because loading the same table several times will only add some weight into our model and may create some performance issues in future. Speaking from experience the DBA’s rarely want to have anything to do with changing tables (this will likely involve creating new tables so this would still require more tables to be loaded into Power BI).

Complete Data Science Education
Get 50% OFF