Connecting to over 100 different data sources

Power Query has connectors for over 100 different data sources. This means you can connect directly to most data sources without the need to first export the data and re-import the static export into Excel. This direct, live connection to data sources is one of the major advantages of using Power Query for report building.

However, there’s a catch with the current connector setups – their availability can be limited by the host application. This means some connectors are available for Power Query in Power BI and not available for Power Query in Excel. You can access the list of Power Query connectors on the Microsoft official page for Power Query, https://powerquery.microsoft.com/en-us/connectors/, and via this GitHub page: https://github.com/olafusimichael/B18312.

If there’s a data source you want to directly connect to and it’s in the preceding list but not available for Power Query in Excel, there’...