Leran Power BI Supported Data Sources

Power BI Supported Data Sources

Power BI supports a wide range of data sources, including:

1. Databases:



• SQL Server
• Azure SQL Database
• Oracle Database
• MySQL
• PostgreSQL
• IBM DB2
• Amazon Redshift
• Google BigQuery
• Snowflake
• SAP HANA
• Teradata
• Salesforce
• MongoDB
• Cassandra



2. File Formats:



• Excel (.xlsx, .xls)
• CSV (Comma Separated Values)
• XML
• JSON
• Text/CSV
• PDF (with Power BI Dataflows)
• Access Database
• SharePoint Lists
• Folder (for data stored in multiple files in a folder)



3. Cloud Services:



• Microsoft Azure (Azure Blob Storage, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Storage, etc.)
• Google Analytics
• Google BigQuery
• Google Sheets
• Salesforce
• Dynamics 365
• Marketo
• Adobe Analytics
• Facebook
• Twitter
• YouTube
• GitHub



4. Other Data Sources:



• OData Feed
• Web (HTML, XML, JSON)
• Hadoop HDFS
• SharePoint Online
• Microsoft Exchange
• Microsoft Exchange Online
• Microsoft Dynamics CRM
• Microsoft Project Online
• Microsoft Power Platform (Power Apps, Power Automate)
• Azure DevOps Services



5. On-Premises Data:



• On-premises SQL Server databases using DirectQuery or Import mode (requires Power BI Gateway)
• On-premises Analysis Services databases (Tabular or Multidimensional) using DirectQuery
• On-premises SharePoint lists and files



6. Custom Data Connectors:



• Power BI allows the creation of custom data connectors using the Power Query M language. This enables connectivity to proprietary data sources or specialized applications.



7. Dataflows:



• Power BI Dataflows allow users to ingest, transform, and store data in the Power BI service, supporting various data sources including files, databases, and cloud services.