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