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.
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
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
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)
Azure Data Sources
The Azure category provides the following data connections:
- Azure SQL Database
- Azure Synapse Analytics (SQL DW)
- Azure Analysis Services database
- Azure Database for PostgreSQL
Online Services Data Sources
The Online Services category provides the following data connections:
- SharePoint Online List
- Microsoft Exchange Online
- Dynamics 365 (online)
- Dynamics NAV
- Dynamics 365 Business Central
- Dynamics 365 Business Central (on-premises)
- Google Analytics
- Adobe Analytics
- LinkedIn Sales Navigator (Beta)
- Twilio (Beta)
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
