Power query supports 30+ data sources from where we can import/extract data. Below are the list of data sources.
Standard Connectors
- Text or CSV file
- Web page
- Excel Table/Range
Import Data from a File
- Excel workbook
- Text or CSV file
- XML file
- JSON file
- Folder
Import Data from a Database
- SQL Server database
- Access database
- SQL Server Analysis Services Database (Import)
- Oracle database
- IBM DB2 database
- MySQL database
- PostgreSQL database
- Sybase IQ database
- Teradata database
Import Data from Microsoft Azure
- Azure SQL database
- Azure HDInsight (HDFS)
- Azure Blob Storage
- Azure Table Storage
- Import Data from Online Services
- Microsoft Exchange Online
- SharePoint Online List
- Microsoft Dynamics 365 (online)
- Facebook
- Salesforce Objects
- Salesforce Reports
Import Data from Other Sources
- Sharepoint List
- OData feed
- Hadoop File (HDFS)
- Active Directory
- Microsoft Exchange
- ODBC source
- OLEDB source
- Create a Blank Query