Power Query Updates in Power BI Desktop September 2021 Release

The Power BI Desktop September 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 September 2021, read the full Power BI blog post here.
The Power BI Connector in Power Automate
We are happy to announce that the Power BI Connector in Power Automate is now in general availability. This connector allows Power BI users to use Power Automate to perform actions within Power BI including refresh a dataset, perform exports on Power BI reports or perform an action when a data driven alert is fired. Over the coming months, we will add additional actions to the connector so stay tuned.
AssembleViews (Connector Update)
This connector is now generally available.
Azure Databricks (Connector Update)
This update adds support for export and import of PBIDS files
Bloomberg Enterprise Data and Analytics (Connector Update)
This connector has been updated. Please find below notes from the Bloomberg team.
“This connector is no longer considered in “Beta.” In addition, our recent update changed the entry field from a single-line to a multiple-line entry so users can see their full BQL query.”
DataVirtuality (Connector Update)
This connector update adds a mapping for string data type with large size to allow usage of that data type in Direct Query Report Visuals. It further improves comfort for handling of unencrypted connections in create connection process.
Exasol (Connector Update)
This update contains the following changes:
- DSN support
- Limited Kerberos authentication support
- Implicit authentication is now also possible
Vena (Connector Update)
This connector is now generally available and has made error handling improvements.
Download Power BI Desktop
The full list of updates for the September release of Power BI Desktop can be found in the Power BI blog post. To access these features, and more, use the link below to download Power BI Desktop!
Feedback
The Power Query team is interested in your feedback! Feel free to leave a comment below with your thoughts.