Page 1 of 1

Data Normalization

Posted: Thu Jan 11, 2018 9:18 pm
by leimst
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

Re: Data Normalization

Posted: Fri Jan 12, 2018 8:41 am
by MattAllington
  • 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

Re: Data Normalization

Posted: Thu Feb 01, 2018 5:40 am
by leimst
Thank you for the high level summary Matt. Exactly what I needed.

leimst

Re: Data Normalization

Posted: Fri Apr 27, 2018 3:52 am
by h_gp9
Hi Matt:
After Normalization, how to carry "reference" to another excel workbook in order to combine with more database.
thanks in advanced.


MattAllington wrote:
  • 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