My organization was using out-of-the-box Power BI data connectors to connect to data sources and create pipelines. However, there were numerous sources that needed a custom connector/pipeline and this was done by:
⚡ Issuing HTTP requests to data sources using Power BI M in the Power Query Advanced Editor
⚡ Transforming and Loading the data using complex M queries (coupled with additional HTTP requests) to complement data