Different Data Sources in Power BI

When utilizing Power BI Desktop, you may connect to data from a broad range of sources. For a complete list of all accessible data sources, see the Power BI data sources page. You may link to the data by using the Home ribbon. To access the Most Common data types menu, choose the Get data button label or the down arrow on the toolbar. Display the most popular data types option, then click the More button to open the Get Data dialogue box. You may also bring up the Get Data dialogue box (skipping the Most Common option) by selecting the Get Data icon directly. This will display the box instead of the Most Common menu.

Data sources

The Get Data dialogue box classifies different types of data using the following categories:
  • All
  • File
  • Database
  • Power Platform
  • Azure
  • Online Services
  • Other
The All category has every type of data connection that can be made from the other categories.

File data sources

The following data connections are available in the File category:
  • Excel Workbook
  • Text/CSV
  • XML
  • JSON
  • Folder
  • PDF
  • Parquet
  • SharePoint folder
The following image shows the Get Data window for File.

Database data sources

The following data connections are available in the Database category:
  • 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(R) Data Virtualization
The following image shows the Get Data window for the Database.

Power Platform data sources

The following data connections are available in the Power Platform category:
  • Power BI datasets
  • Datamarts (preview)
  • Power BI dataflows (Legacy)
  • Common Data Service (Legacy)
  • Dataverse
  • Dataflows
The following image shows the Get Data window for the Power Platform.

Azure data sources

The following data connections are available in the Azure category:
  • 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)
The following image shows the Get Data window for Azure.

Online Services data sources

The following data connections are available in the Online Services category:
  • 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
The following image shows the Get Data window for Online Services.

Other data sources

The following data connections are available in the Other category:
  • 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
The following image shows the Get Data window for Other.

Template apps

You may find template applications that are suitable to your organization by clicking the Template Apps option towards the bottom of the Get Data box. Depending on your industry, the amount of Template Apps accessible to you may vary.

As you can see, business intelligence has a lot to offer businesses of all sizes across all industries. If you’re not already using BI in your decision-making process, now is the time to start! 

Check out other helpful Power BI Blogs

Follow us on TwitterFacebook, Linkedin to stay updated with our latest blog and what’s new in Power BI.

If you are looking forward to getting your data pipeline built and setting up the dashboard for business intelligence, book a call now from here.

Established in 2020, Lets Viz Technologies provides a full range of high-quality data analysis and data visualization services. We are also an authorized Zoho Partner.

 

Contact

WeWork Berger Delhi One, C-001/A2, Sector 16B, Noida, Uttar Pradesh 201301

0124-502-5592
info@lets-viz.com

We are Social

Trust Pilot Reviews