How to Connect Google Sheets to Power BI

How to Connect Google Sheets to Power BI

Microsoft recently introduced Google Sheets as a data source for Power BI, enabling the visualization and manipulation of Google Sheets data on its platform.

To make this connection, follow the steps below. And if you want to know how to set up automatic import from more than 80 data sources to Google Sheets, click here .

1. Go to the Google Sheets spreadsheet that will be connected to Power BI and copy its URL.

foto 1.webp

2.Enter Power BI and click the “Get Data” button.

foto 2.webp

3.In the screen that opens, look for “Google Sheets,” select the corresponding option, and click “Connect.”

foto 3.webp

4.Paste the full URL copied in step 1 and click “Ok.”

foto 4.webp

5.Power BI will then ask you to connect to your Google account. Click on “Sign in.”

foto 5.webp

6.Select the Google account you wish to use for the connection. Attention: Ensure that the chosen account has access to the spreadsheet to be connected.

foto 6.webp

7.At this step, Google will ask you to confirm that Power BI can access your Google account. Click “Continue.”

foto 7.webp

8.You can now return to Power BI and click on “Connect.”

foto 8.webp

9.Select the tab(s) of the spreadsheet you want to connect and click on “Transform Data.”

foto 9.webp

10.We will make a small adjustment so that Power BI understands the first line of the Google sheet as a header. In the Power Query Editor that opens, click on the table icon (first square of the first line of the table), and then click on “Use First Row as Header.”

foto 10.webp

11.Note that now the first row is bringing the names of the columns from your Google sheet. Click on “Close and Apply” to exit Power Query.

foto 11.webp

12.Done! Now your Google Sheets data will be available in Power BI.

foto 12.webp

Updating Google Sheets Data in Power BI 

  • Power BI Desktop
foto 13.webp

To update the data from Google Sheets in Power BI Desktop, click the “Refresh” button on the Home tab.

  • Power BI online
foto 14.webp

In premium versions of Power BI, you can set a scheduled update so that data is refreshed as frequently as you define. To do this, in the navigation pane, under “Dataset,” select the set, and then click on Update > Schedule Update.

Importing Data in Google Sheets to Connect it to Power BI

The best way to import data from Google Sheets to connect it to Power BI is by using a tool that performs these imports automatically so that you don’t have to worry about manually downloading data or creating complicated scripts.

With the Kondadoplatform, it is possible to automatically bring data from more than 80 tools and databases to Google Sheets as frequently as you prefer, configuring it with just a few clicks.