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. 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 connection of your data to Azure, which is then used to connect to the Power BI dashboards.

File Data Sources

Excel
Text/CSV
XML
JSON
Folder
PDF
SharePoint folder
Power Platform Data Sources

Power BI datasets
Power BI dataflows
Common Data Service
Power Platform dataflows (Beta)
Azure Data Sources

Azure Analysis Services database
Azure Blob Storage
Azure Cosmos DB
Azure Cost Management
Azure Data Explorer (Kusto)
Azure Data Lake Storage Gen1
Azure Data Lake Storage Gen2
Azure Database for PostgreSQL
Azure Databricks
Azure HDInsight (HDFS)
Azure HDInsight Spark
Azure SQL Database
Azure Synapse Analytics (SQL DW)
Azure Table Storage
Azure Time Series Insights (Beta)
HDInsight Interactive Query
Database Data Sources

Access database
Amazon Redshift
AtScale cubes
BI Connector
Data Virtuality LDW (Beta)
Denodo
Dremio
Essbase
Exasol
Google BigQuery
IBM Db2 database
IBM Informix database (Beta)
IBM Netezza
Impala
Indexima
InterSystems IRIS (Beta)
Jethro (Beta)
Kyligence
Linkar PICK Style / MultiValue Databases (Beta)
MariaDB (Beta)
MarkLogic
MySQL database
Oracle database
PostgreSQL database
SAP Business Warehouse Application Server
SAP Business Warehouse Message Server
SAP HANA database
Snowflake
SQL Server Analysis Services database
SQL Server database
Sybase database
Teradata database
Vertica
Online Services Data Sources

Adobe Analytics
appFigures (Beta)
Asana (Beta)
Azure DevOps (Boards only)
Azure DevOps Server (Boards only)
Data.World - Get Dataset (Beta)
Dynamics 365 (online)
Dynamics 365 Business Central
Dynamics 365 Business Central (on-premises)
Dynamics 365 Customer Insights (Beta)
Dynamics NAV
Emigo Data Source
Entersoft Business Suite (Beta)
FactSet Analytics
GitHub (Beta)
Google Analytics
Hexagon PPM Smart API
Industrial App Store
Intune Data Warehouse (Beta)
LinkedIn Sales Navigator (Beta)
Marketo (Beta)
Microsoft Azure Consumption Insights (Beta)
Microsoft Exchange Online
Microsoft Graph Security (Beta)
Mixpanel (Beta)
Palantir Foundry
Planview Enterprise One - CTM (Beta)
Planview Enterprise One - PRM (Beta)
Product Insights (beta)
Projectplace for Power BI (Beta)
Quick Base
QuickBooks Online (Beta)
Salesforce Objects
Salesforce Reports
SharePoint Online List
Smartsheet
SparkPost (Beta)
SweetIQ (Beta)
TeamDesk (Beta)
Twilio (Beta)
Webtrends Analytics (Beta)
Witivio (Beta)
Workplace Analytics (Beta)
Zendesk (Beta)
Zoho Creator (Beta)
Other Data Sources

Acterys : Model Automation & Planning (Beta)
Active Directory
Automation Anywhere (Beta)
Blank Query
Cherwell (Beta)
Cognite Data Fusion (Beta)
FHIR
Hadoop File (HDFS)
Hive LLAP (Beta)
Information Grid (Beta)
Jamf Pro (Beta)
Microsoft Exchange
MicroStrategy for Power BI
OData Feed
ODBC
OLE DB
Paxata
Python script
QubolePresto (Beta)
R script
Roamler (Beta)
SharePoint list
Shortcuts Business Insights (Beta)
Siteimprove
Solver
Spark
SurveyMonkey (Beta)
Tenforce (Smart)List
TIBCO(R) Data Virtualization (Beta)
Vena (Beta)
Vessel Insight (Beta)
Web
Zucchetti HR Infinity (Beta)

Latest List of Data Sources Available

Check out the latest supported data sources and file formats from Microsoft Power BI's website.

Let us work on your data challenges