Power Query (Get & Transform) Part 1

Microsoft Power Query Connections

Power Query is amazing at linking to data sources and cleansing / transforming that data as it’s loaded into Excel (or Power BI Desktop).

Watch this 4 minute video and see how you can consolidate all of the files from a folder instantly using Power Query.

Build the transformation steps once and then every time you need to reload data you just RIGHT-CLICK refresh!

 

Supporting Files

Download Source CSV Files if you’d like to try this out yourself

 

Information

For more information  on Power Query and Power BI then please read this article

 

Training

For training courses in Power Query and Power BI please click here