Use Query Editor  with multiple tables in Power BI Lesson-7

1. First of all load data in Power BI from Get data option of Home tab
   • Home -> Get data -> Excel workbook
   • Select required work book from browsing window 
   • Click on Load button
2. Open Query Editor
   • Home ->Transform data -> Transform data
   • 
   • Then we have
   • 
3. Load (call) an other table
   • Home -> New source -> Excel workbook
   • 
   • Select required workbook and click on open button
   • 
   • Then you have
   • 

• Table one data (astdata)
  • 
• 2nd table data (stdata(2))
  •  

Microsoft Power BI Table of Contents: Lessons Index