Data Connections
Data connections are key to any good business data analysis. When you have the right data connections, you can easily bring in the data into the same platform to analyze them. This means that you can build your data connections just like building blocks, with each block bringing greater value to your organization.
You may first start with only one block, but as your company grows, you might start to utilize other data sources. Being able to have the large range of supported data connections means that you are future-proofing your investment into your data operations.
Below are the list of data connections and file formats that are currently supported within Power BI. This means that all these can be directly connected to the Power BI dashboards that we build for you.
If the data source which you are using is not currently supported, there are usually ways around the problem which can be resolved, such as connecting your data via APIs to a data warehouse, which is then used to connect to the Power BI dashboards.
File Data Sources
- Excel
- Text/CSV
- XML
- JSON
- Folder
- Parquet
- SharePoint folder
Power Platform Data Sources
- Power BI datasets
- Datamarts (preview)
- Power BI dataflows (Legacy)
- Common Data Service (Legacy)
- Dataverse
- Dataflows
Azure Data Sources
- Azure SQL Database
- Azure Synapse Analytics SQL
- Azure Analysis Services database
- Azure Database for PostgreSQL
- Azure Blob Storage
- Azure Table Storage
- Azure Cosmos DB v1
- Azure Data Explorer (Kusto)
- Azure Data Lake Storage Gen2
- Azure Data Lake Storage Gen1
- Azure HDInsight (HDFS)
- Azure HDInsight Spark
- HDInsight Interactive Query
- Azure Cost Management
- Azure Databricks
- Azure Synapse Analytics workspace (Beta)
- Azure Time Series Insights (Beta)
Online Services Data Sources
- SharePoint Online List
- Microsoft Exchange Online
- Dynamics 365 Online (legacy)
- Dynamics 365 (Dataverse)
- Dynamics NAV
- Dynamics 365 Business Central
- Dynamics 365 Business Central (on-premises)
- Azure DevOps (Boards only)
- Azure DevOps Server (Boards only)
- Salesforce Objects
- Salesforce Reports
- Google Analytics
- Adobe Analytics
- appFigures (Beta)
- Data.World - Get Dataset (Beta)
- GitHub (Beta)
- LinkedIn Sales Navigator (Beta)
- Marketo (Beta)
- Mixpanel (Beta)
- Planview Enterprise One - PRM (Beta)
- QuickBooks Online (Beta)
- Smartsheet
- SparkPost (Beta)
- SweetIQ (Beta)
- Planview Enterprise Architecture
- Zendesk (Beta)
- Asana (Beta)
- Assemble Views
- Automation Anywhere
- Automy Data Analytics (Beta)
- Dynamics 365 Customer Insights (Beta)
- Databricks (Beta)
- Digital Construction Works Insights (Beta)
- Emigo Data Source
- Entersoft Business Suite (Beta)
- eWay-CRM
- FactSet Analytics
- Palantir Foundry
- Funnel
- Hexagon PPM Smart® API
- Industrial App Store
- Intune Data Warehouse (Beta)
- Projectplace for Power BI
- Product Insights (Beta)
- Profisee (Beta)
- Quickbase
- SoftOne BI (Beta)
- Spigit (Beta)
- TeamDesk (Beta)
- Webtrends Analytics (Beta)
- Witivio (Beta)
- Viva Insights
- Zoho Creator
Database Data Sources
- SQL Server database
- Access database
- SQL Server Analysis Services database
- Oracle database
- IBM Db2 database
- IBM Informix database (Beta)
- IBM Netezza
- MySQL database
- PostgreSQL database
- Sybase database
- Teradata database
- SAP HANA database
- SAP Business Warehouse Application Server
- SAP Business Warehouse Message Server
- Amazon Redshift
- Impala
- Google BigQuery
- Google BigQuery (Azure AD)(Beta)
- Vertica
- Snowflake
- Essbase
- Actian (Beta)
- Amazon Athena
- AtScale cubes
- BI Connector
- Data Virtuality LDW
- Denodo
- Dremio Software
- Dremio Cloud (Beta)
- Exasol
- Indexima
- InterSystems IRIS (Beta)
- Jethro (Beta)
- Kyligence
- Linkar PICK Style / MultiValue Databases (Beta)
- MariaDB
- MarkLogic
- TIBCO® Data Virtualization
Other Data Sources
- Web
- SharePoint list
- OData Feed
- Active Directory
- Microsoft Exchange
- Hadoop File (HDFS)
- Spark
- Hive LLAP
- R script
- Python script
- ODBC
- OLE DB
- Acterys : Model Automation & Planning (Beta)
- Amazon OpenSearch Service (Beta)
- Anaplan Connector
- Autodesk Construction Cloud (Beta)
- Solver
- BitSight Security Ratings
- BQE Core
- Bloomberg Data and Analytics
- Cherwell (Beta)
- Cognite Data Fusion
- Delta Sharing
- Eduframe (Beta)
- EQuIS (Beta)
- FactSet RMS (Beta)
- FHIR
- Google Sheets
- Information Grid (Beta)
- Jamf Pro (Beta)
- Kognitwin
- MicroStrategy for Power BI
- OpenSearch Project (Beta)
- Paxata
- QubolePresto (Beta)
- Roamler (Beta)
- SIS-CC SDMX (Beta)
- Shortcuts Business Insights (Beta)
- SingleStore Direct Query Connector 1.0 (Beta)
- Siteimprove
- Socialbakers Metrics 1.1.0 (Beta)
- Starburst Enterprise
- SumTotal
- SurveyMonkey (Beta)
- Microsoft Teams Personal Analytics (Beta)
- Tenforce (Smart)List
- Usercube (Beta)
- Vena
- Vessel Insight
- Zucchetti HR Infinity (Beta)
- Blank Query
Latest List of Data Sources Available
As there are updates from time to time from Microsoft, such as new connections being added, you might want to check out the following source which is kept updated by Microsoft.