How to connect google sheet with power bi?

Question

I am trying to connect google sheet with power bi using R Studio, there is a video on youtube by stephnie locke, but that is just a short video and don't help completely. anyone there who can help properly and completely.

Answer 1

• If one is not limited to R Studio, there is another way to access Google Sheet data from Power BI:

Sample data:

1. Get the shareable link of the Google Sheet (Permission at least Anyone with the link can view):

• Modify the shareable link and add the following parts:
  From:
  https://docs.google.com/spreadsheets/d/google-sheet-guid/edit?usp=sharing
  To:
  https://docs.google.com/spreadsheets/d/google-sheet-guid/export?format=xlsx&id=google-sheet-guid

If u want to learn the tool in depth, then come to us and sign up for this Power BI Certification course online at Intellipaat. 

Answer 2

For non-technical users, the easiest way to connect Google Sheets with power BI is to use the no-code approach https://docs.dataddo.com/docs/connecting-to-bi to save time and extra effort. Without writing a single line of code, you can automatically deliver data from Google Sheets to the destination of your choice, like Power BI, Amazon SQL and Azure SQL