Skip to main

Power Query Updates in Power BI Desktop July 2021 Release

This content applies to: Power BI Desktop

The Power BI Desktop July 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 July 2021, read the full Power BI blog post here.

Amazon Athena (new connector)

We are excited to announce the release of the Amazon Athena connector! Below is an excerpt from the Amazon Athena team on this release.

“Amazon Athena is an interactive query service that makes it easy to analyze data stored in Amazon S3 and other relational, non-relational, and custom data sources through federated queries. Using the Amazon Athena connector for Microsoft Power BI, you can now query, analyze, visualize, and share insights from your data lake with teammates across your organization.”

Visit our Power Query documentation or the Amazon Athena team tutorial for more information on how to get started.

Databricks (updated connector)

This update includes improved stability and performance of large imports and fixes an issue with the handling of invalid credentials.

Dremio (updated connector)

This update fixes an issue where any error would cause Power BI to repeatedly display an “Encryption Support” prompt.

MariaDB (updated connector)

This update includes a fix for misreported COLUMN_SIZE for the VARCHAR data type.

Download Power BI Desktop

The full list of updates for the July release of Power BI Desktop can be found in the July 2021 Power BI Feature Summary blog post. To access these features, and more, use the link below to download Power BI Desktop!

Desktop Download button


The Power Query team is interested in your feedback! Feel free to leave a comment below with your thoughts.