You can select the Sheet(s) to import to the Power Query Editor experience and continue to transform your data there. Once authenticated, you will be shown the Navigator experience showing all the individual Sheets within the specified Google Sheet. When you select “Sign in”, an external browser window will open, and you will need to log in to your Google Account and give permission for Power BI Desktop to access your Google Sheets. Simply copy paste in a Google Sheet URL that you have access to into the input and select OK.Īuthentication for the connector is done through standard Google OAuth.
The Google Sheets connector is built on top of the Google Sheets API and enables out-of-box connectivity to Google Sheets.Īfter selecting “Google Sheets” in the Power BI Get Data experience, you will be prompted to enter a Google Sheet URL. We have understood the strong community need for this connector and are excited to announce the release of the Google Sheets connector! Google Sheets (New Connector)Ĭonnecting to Google Sheets is the most upvoted connector-related idea on the Power BI Ideas forum. With the support for related tables and auto import of relationships from Synapse to Power BI Desktop, users can now use their Synapse data to speed up the time to results!įor scenarios which need leveraging features such as direct query and native query on the SQL DBs, users should continue to use the existing Synapse Connector (Azure Synapse Analytics (SQL DW)), as these functionalities aren’t supported in this Public Preview version of Azure Synapse Analytics workspace (Beta) connector. The connector automatically discovers Synapse Workspaces that users have access to (via ARM). We are excited to announce the launch of the Public Preview of the Azure Synapse Analytics Workspace (Beta) connector for Power BI Desktop that enables users to work with all Synapse Databases.
To view the full list of feature releases in Power BI Desktop November 2021, read the full Power BI blog post here.
The Power BI Desktop November 2021 Release contains many Power Query-related updates, summarized below for easy reference. This content applies to: Power BI Desktop