How To Break Out Large Tables Into Multiple Tables And Build A Model - Power BI Tips

How do you clean up a huge flat database file from SQL server into Power BI? This is a common question in the Enterprise DNA Support Forum and I want to do a quick deep dive into this simple process.

I will show you how to manage a huge flat file by breaking large tables into multiple tables and create a structured model.

You must understand that this process cannot be done on the front-end but in the Power Query Editor.

***** Video Details *****
1:34 - transforming the data using Power BI Query Editor
3:15 - changing a column into a lookup table
4:00 - create abbreviations and index
6:17 - removing column and putting related columns together

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-gu…
FREE COURSE – Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-gu…
FREE – 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-do…
FREE – Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/


*****Related Links*****
Creating Dynamic Ranking Tables Using RANKX In Power BI - blog.enterprisedna.co/dynamic-ranking-tables-in…
Master Virtual Tables in Power BI Using DAX - blog.enterprisedna.co/working-with-virtual-in-m…
Creating Power BI Tables By Using UNION & ROW Function - blog.enterprisedna.co/creating-power-bi-tables-…


*****Related Course Modules*****
Data Visualization Tips - portal.enterprisedna.co/p/data-visualization-ti…
Advanced DAX Combinations - portal.enterprisedna.co/p/advanced-dax-combinat…
Advanced Data Transformations & Modeling - portal.enterprisedna.co/p/advanced-data-transfo…


*****Related Forum Posts*****
How To Create A New Table From Many Other Similar Tables - forum.enterprisedna.co/t/how-to-create-a-new-ta…
How To Break Out Large Tables Into Multiple Tables And Build A Model – Power BI Tips - forum.enterprisedna.co/t/how-to-break-out-large…
Creating A New Table From Multiple Other Tables With Similar Data - forum.enterprisedna.co/t/creating-a-new-table-f…
For more power BI table queries to review see here - forum.enterprisedna.co/search?q=power%20bi%20ta…