Power BI Tutor

Bookmarks: Clear all bookmarks. CTRL-SHIFT-F2 Bookmarks: Insert or remove a bookmark (toggle). CTRL+F2 Bookmarks: Move to next bookmark. F2 Bookmarks: Move to previous bookmark. SHIFT+F2 Cancel a query. ALT+BREAK Connections: Connect. CTRL+O Connections: Disconnect. CTRL+F4 Connections: Disconnect and close child window. CTRL+F4 Database objects information. ALT+F1 Editing: Clear the active Editor pane. CTRL+SHIFT+ DEL Editing: Comment out code. CTRL+SHIFT+C Editing: Copy. You can also use CTRL+INSERT. CTRL+C Editing: Cut. You can also use SHIFT+DEL. CTRL+X Editing: Decrease indent. SHIFT+TAB Editing: Delete through the end of a line in the Editor pane. CTRL+DEL Editing: Go to a line number. CTRL+G Editing: Increase indent. TAB Editing: Make selection lowercase. CTRL+SHIFT+L Editing: Make selection uppercase. CTRL+SHIFT+U Editing: Remove comments. CTRL+SHIFT+R Editing: Repeat las...

Union Union All used to combine ( set operation ) two or more query results Used to combine (set operation) two or more query results UNION will eliminate duplicate rows UNION ALL will display all rows.

   Merge Merge Join The data from 2 input paths are merged into one  The data from 2 inputs are merged based on some common key. Works as UNION ALL   JOIN (LEFT, RIGHT OR FULL) Supports 2 Datasets Supports 1 Datasets Metadata for all columns needs to be same  Key columns metadata needs to be same. Data must be sorted. Data must be sorted. Does not support error handling Does not support error handling