In Excel, Power Query is an add-in that provides a user-friendly interface for data discovery, transformation, and enrichment. It can…