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.
If one is not limited to R Studio, there is another way to access Google Sheet data from Power BI:
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=sharingTo:https://docs.google.com/spreadsheets/d/google-sheet-guid/export?format=xlsx&id=google-sheet-guid