Power Query Updates in Power BI Desktop May 2021 Release
The Power BI Desktop May 2021 Release contains many Power Query-related updates, summarized below for easy reference. To view the full list of feature releases in Power BI Desktop May 2021, read the full Power BI blog post here.
New Connector: EQuIS
We are excited to announce the release of the EQuIS connector in Power BI Desktop. Here’s more about the connector from the EQuIS team:
“The EQuIS data connector for Power BI unleashes the power of EQuIS data by enabling users to directly and easily access EQuIS data in Microsoft Power BI via the EQuIS Enterprise REST API. The EQuIS connector supports three types of user authentication: basic, API token, and organizational account (aka Azure Active Directory). Through a secure, encrypted connection to the EQuIS REST API, the EQuIS connector allows users to import a variety of EQuIS datasets into Power BI (including facility data, location data, and tabular report data). In addition to powerful analytics and visualization, importing EQuIS data into Power BI allows users to combine their EQuIS environmental data with a myriad of other datasets and share those data across organizations easily and efficiently with Power BI collaboration tools.”
Connector Update: Automation Anywhere
The Automation Anywhere connector has been updated. The A2019 cloud version has been updated and renamed to Automation 360 within the connector.
Connector Update: Vena
The Vena connector has also been updated. This updated version includes support for rollup operators from Vena.
Connector Update: Azure Databricks
The Azure Databricks connector has been updated with the following:
- Better support for Unicode characters in Direct Query mode
- The “Batch Size” option is now deprecated and removed from the Connector dialog but can still be provided in the Advanced (Query) Editor. Existing saved connections are not affected.
- Minor improvements in query generation
Connector Update: Amazon Redshift
The Amazon Redshift connector has been updated to enable AAD Authentication in Power BI Desktop. Please note that this type of authentication is not available in the Service.
Connector Update: Vertica
The Vertica connector has been updated with a bug fix to support supplying a port value when connecting to Vertica.
Connector Deprecation: Microsoft Graph Security
The Microsoft Graph Security connector is being deprecated due to ending support from the data source service. This update will remove the connector from the “Get Data” experience in Power BI Desktop, discouraging new connections from being made. Existing connections and reports will continue to work for now. Up-to-date deprecation information can be found in our documentation.
The Power Query team is interested in your feedback! Feel free to leave a comment below with your thoughts.