New and enhanced connectors in Power Query Online
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
| Enabled for | Public preview | General availability |
|---|---|---|
| Admins, makers, or analysts, automatically | - |  Mar 30, 2020 |
Feature details
We will improve existing connectors, bringing support for native database queries and other connector advanced options, including time-outs and hierarchical navigation.
Here's a list of the new database, folder, and cube connectors:
Database connectors
- HDInsight Spark
- Apache Spark
- HDInsight Interactive Query
- Google BigQuery
- Power Platform Dataflows
- Impala
- Snowflake
- Common Data Service Connector
Folder connectors
- Local Folder
- SharePoint Folder
- SharePoint Online Folder
- Azure Data Lake Storage Gen2
Cube Connectors
- SAP HANA
- SAP BW
- SQL Server Analysis Services
- Azure Analysis Services
- Google Analytics
- Adobe Analytics
We'll also increase investments in the following categories of connectivity.
| Connector | Description |
|---|---|
| Generic ODBC | This connector, which is widely used in Power BI Desktop, will become available in Power Query Online to enable connectivity to any data source that provides an ODBC interface. |
| PDF Files | This connector will be available in Power Query Online. |
New data preparation capabilities in Power Query Online will bring it closer to parity with Power Query Desktop in these areas:
| Transformation | Description |
|---|---|
| Table | Includes fill up, fill down, pivot, extract text, before, after, or between delimiters, keep or remove characters, split by character transition, append queries, combine files, and more. |
| List | Includes keep or remove, top, bottom or duplicates, alternate, reverse, sort, and statistics, including sum, avg, min, max, std, count, and countD. |
| Scalar | Includes text transforms (ToList, table, split, and format. Upper, lower/capitalize, trim, clean, prefix, and suffix), extract (length, first, last, range), and parse (JSON/XML). |