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):