Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
Mastering Power Query will allow you to clean, tidy and reorganise data so it meets your needs, before loading into Power BI or Excel
Before you can report on your data, it invariably requires cleaning and restructuring before it can be imported into the Business Intelligence tools you're using. The Power Query editor provides a tool to clean, tidy and reorganise your data so it can be reported on by Power BI or loaded into Excel.