What Data Sources can Microsoft Power BI Desktop connect to?

It goes without saying, but data is at the heart of Power BI.

When you are exploring data within Power BI, by creating charts, dashboards or asking questions for example. The visualisations and answers you see are getting their underlying data from a dataset; this dataset comes from a data source.

Below, we will cover a few of the data source types within Power BI Desktop:

You connect to data by using the Home ribbon. To show the Most Common data types menu, select the Get Data button label or the down arrow.

Power BI Desktop Get Data Sources

To go to the Get Data dialog box, show the Most Common data types menu and select More. You can also bring up the Get Data dialog box (and bypass the Most Common menu) by selecting the Get Data icon directly.

Power BI Desktop Navigate to Get Data Sources

Data Sources

The Get Data dialog box organizes data types in the following categories:

  • All
  • File
  • Database
  • Power Platform
  • Azure
  • Online Services
  • Other

The All category includes all data connection types from all categories.

File Data Sources

The File category provides the following data connections:

  • Excel
  • Text/CSV
  • XML
  • JSON
  • Folder
  • PDF
  • SharePoint folder

The following image shows the Get Data window for File.

Power BI Desktop File Data Sources

Database

The Database category provides the following data connections (this is a shortened list, view the full list here):

  • SQL Server database
  • Access database
  • SQL Server Analysis Services database
  • Oracle database
  • MySQL database
  • Google BigQuery
  • MarkLogic
  • BI Connector

The following image shows the Get Data window for Database.

Power BI Desktop Database Data Sources

Power Platform Data Sources

The Power Platform category provides the following data connections:

  • Power BI datasets
  • Power BI dataflows
  • Microsoft Dataverse
  • Power Platform dataflows (Beta)

The following image shows the Get Data window for Power Platform.

Power BI Desktop Power Platform Data Sources

Azure Data Sources

The Azure category provides the following data connections (this is a shortened list, view the full list here):

  • Azure SQL Database
  • Azure Synapse Analytics (SQL DW)
  • Azure Analysis Services database
  • Azure Database for PostgreSQL

The following image shows the Get Data window for Azure.

Power BI Desktop Azure Data Sources

Online Services Data Sources

The Online Services category provides the following data connections (this is a shortened list, view the full list here):

  • SharePoint Online List
  • Microsoft Exchange Online
  • Dynamics 365 (online)
  • Dynamics NAV
  • Dynamics 365 Business Central
  • Dynamics 365 Business Central (on-premises)
  • Salesforce Objects
  • Salesforce Reports
  • Google Analytics
  • Adobe Analytics
  • LinkedIn Sales Navigator (Beta)
  • Twilio (Beta)
  • Zendesk (Beta)
  • Asana (Beta)
  • Dynamics 365 Customer Insights (Beta)
  • Zoho Creator (Beta)

The following image shows the Get Data window for Online Services.

Power BI Desktop Online Services Sources

Other Data Sources

The Other category provides the following data connections (this is a shortened list, view the full list here):

  • Web
  • SharePoint list
  • Active Directory
  • Microsoft Exchange
  • Python script
  • ODBC
  • Automation Anywhere (Beta)
  • MicroStrategy for Power BI
  • Paxata
  • Siteimprove
  • SurveyMonkey (Beta)
  • Blank Query

The following image shows the Get Data window for Other.

Power BI Desktop Other Data Sources

Want to learn more about Microsoft Power BI?

Click here to view our Power BI page

Get in touch…

If you would like more information about Microsoft Power BI, please get in touch by emailing us at [email protected] or calling us on 01908 038110. Alternatively, fill out the form below and a member of our team will be in touch shortly.

    More FAQs

    Frequently Asked Questions

    I use Zoho One. Why would I use Dynamics 365?

    I use Zoho One. Why would I use Dynamics 365? Selecting the right CRM Software for your company is complicated with various features, options, and…
    Frequently Asked Questions

    What is the difference between Dynamics 365 Cloud and On-Premise?

    What is the difference between Dynamics 365 Cloud and On-Premise? Cloud and on-premise are the two main deployment options for Dynamics 365. However, over the…
    crm key benefits cover image
    Frequently Asked Questions

    What are the key benefits of a CRM System?

    What are the key benefits of a CRM System? There are many reasons why a business might invest in Customer Relationship Management (CRM) software. Within…