GOOGLE SHEETS TO POWER BI

Question

how to trasfer or add the info from google sheets into power bi

Answer 1

Hi @ainul najihah, 

Thank you for posting your question in the Microsoft Q&A forum. 

To convert or connect your Google Sheets data to Power BI, you can follow either the recommendations mentioned earlier or use the step-by-step guide below: 

Steps to connect Google Sheets to Power BI 

1. Open Power BI  
2. Select Create 
3. Click on Get Data 
4. Look for and choose the option to connect to Google Sheets 
5. Copy the URL of your Google Sheet and paste it into Power BI 
6. Sign in with your Google account when prompted 
7. Click Next 

After completing these steps, your Google Sheets data will be loaded into Power Query, where you can review and transform the data as needed before loading it into your report. 

(The image shown is for illustration purposes.) 

Thank you again for your time and understanding. While this may not immediately resolve your issue, it provides the most effective path to move forward. I appreciate your patience, and I’m here to assist further please feel free to share any updates or additional details. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".                         

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

To transfer or add data from Google Sheets into Power BI, use the built-in Google Sheets connector in Power BI (Power Query).

Steps in Power BI Desktop (Power Query Desktop experience):

1. Open Power BI Desktop.
2. On the Home ribbon, select Get data.
3. Search for and select Google Sheets.
4. When prompted, paste the URL of the Google Sheet (copy it from the browser address bar while viewing the sheet).
5. Select Sign in and authenticate with the Google account that has access to the sheet.
6. Approve access in the Sign in with Google browser window.
7. After successful sign-in, select Connect.
8. In the Navigator window, select the sheet(s) you want.
   • Choose Load to bring the data directly into Power BI.
   • Choose Transform Data to open Power Query and clean/shape the data before loading.

Steps in Power BI Service / Power Query Online / Fabric Dataflow Gen2:

1. In the dataflow or Power Query Online experience, go to Connect to data source.
2. Select Google Sheets.
3. Enter the Google Sheet URL.
4. Select Sign in and authenticate with the Google account.
5. After sign-in, select Next.
6. On Choose data, select the sheet(s) to load.
7. Select Transform data if data needs shaping in Power Query Editor, then save/load the dataflow or model.

Key considerations:

• The connector only supports Import mode (data is copied into Power BI).
• The URL must start with https://docs.google.com/spreadsheets/d/ because the connector parses the spreadsheet ID from this pattern.
• Each Google Sheet URL is treated as a separate connection (ResourcePath), so new sheets may require re-authentication.
• Shared drives are supported as long as the Google account has access.

Once loaded, the Google Sheets data appears as a table in the Fields pane in Power BI Desktop or in the dataflow, and can be used in reports and visuals like any other data source.

---

References:

• Google Sheets
• Set up your Google Sheets connection