Basic ETL Exercise in Power BI


Please watch this video before doing the exercise.

ETL-2 video link

Download the data from here: Github link


1. Get the excel file into the Power BI
2. Launch Power Query Editor
3. Check all the columns are properly named (if not, name it properly)
4. Remove the null values (Rows)
5. Delete the irrelevant columns
6. Add a new table with simple columns.

If you face any issues, please comment. 


Popular posts from this blog

Learning Path: Business Central Technical Consultant | Dynamics 365 Business Central

Top Business Central Interview Questions for Technical Consultants: Tips and Strategies for Nailing Your Interview

Table in Business Central