Answer: To enable Power Query, follow these steps:
Click the “Data” tab in the ribbon (at the top of the Excel worksheet).
Select “Get Data“.
Choose “Launch Power Query Editor” from the dropdown menu.
Q2. Is Power Query available in all Excel?
Answer: Power Query is available in all stand-alone Windows versions of Excel 2016 or later, as well as with subscription plans of Microsoft 365.