Data Normalization

leimst
Posts: 27
Joined: Wed Feb 25, 2015 4:51 am

Data Normalization

Postby leimst » Thu Jan 11, 2018 9:18 pm

Good Morning All,

Looking for a high level description of how to take a large flat table and divy it up into multiple tables, e.g. one fact table and multiple lookup tables, using Power Query.

Thank you in advance,

leimst

MattAllington
Posts: 919
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Data Normalization

Postby MattAllington » Fri Jan 12, 2018 8:41 am

  • connect to the source data
  • set this query so it doesn't load. In PBI, right click and turn off "enable load". In Excel, "close and load", "Connection only"
  • go back into power query, right click on the above query, select "reference"
  • build table 1
  • repeat the 2 steps above for each additional table
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

leimst
Posts: 27
Joined: Wed Feb 25, 2015 4:51 am

Re: Data Normalization

Postby leimst » Thu Feb 01, 2018 5:40 am

Thank you for the high level summary Matt. Exactly what I needed.

leimst


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 5 guests