


In the Excel Options dialog box, click Add-ins. Reload the Microsoft Power Query for Excel COM Add-In Most of the time the solution is quite simple: just reload the Microsoft Power Query for Excel COM add-in. This is due to the Microsoft Power Query for Excel COM add-in failing to load. There may be times after you install Power Query when the POWER QUERY tab does not appear. To learn more, see Get & Transform in Excel 2016. Information provided here applies to both. Note: Power Query is known as Get & Transform in Excel 2016.
