Getting Started with Power Query. 1. Open Excel and ensure that the Data tab is visible. If it is not, you can enable it by going to File > Options > Customize Ribbon and checking the Data box.