
Home Tab in Query Editor: Add new data file in query editor: Lesson-7
Use Query Editor with multiple tables in Power BI Lesson-7
- 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
- Open Query Editor
- Home ->Transform data -> Transform data
- Then we have
- 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))