Advice Needed: How to Pull Data from Multiple Cloud Platforms Without ODBC Connectors into PowerBI

Hi! One option would be to have the data landed in a lakehouse or datawarehouse then connect to that. Another option would be to use APIs to get the data: How to Pull Data From an Api and Put It in Power BI - Zebra BI

Hi sajohnson05 

There are third-party tools and services that provide Power BI connectors for various platforms. You might find a suitable connector for your third-party systems.

Power BI allows you to create custom connectors for sources that are not natively supported. This is a more advanced technique and might require some development skills, here are some links may help you:

Custom Data Connector: How to Deploy and Test - Microsoft Fabric Community

Creating your first connector - Hello World - Power Query | Microsoft Learn

Power BI Custom Connector: Connect to Any Data Sources. Hello World! - RADACAD

Connector extensibility in Power BI - Power BI | Microsoft Learn

There are many data sources that provide REST APIs for integration with other data processing software, you can look for the REST APIs provided by your data source, and then write mcode in PowerQuery to connect to the data source.

I have the Power(query): using Power Query to call REST APIs | Burningsuit

Read API Data with Power BI using Power Query (mssqltips.com)

Solved: Re: Using a REST API as a data source - Page 6 - Microsoft Fabric Community

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.