You need a connector to work with data in Power Query for Power BI or Excel. But what is a connector? Adam explains what these are and how to find out what’s available.

Power Query Connectors:

Power BI data sources:

Import vs DirectQuery vs Live video:

Power Query Custom Connectors:

CDATA Custom Connectors (Paid items):