How to connect google sheet with power bi

0 votes
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 dont help completely. any one there which can help properly and completely.
Dec 22, 2020 in Power BI by Rajiv
• 8,910 points
601 views

1 answer to this question.

0 votes

If you're not limited to R Studio, there is another way to access Google Sheet data from Power BI:

Sample data: sample

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

shareable link​2. Create a blank query in Power BI and get the source as below:

let Source = Excel.Workbook(Web.Contents("the-link-in-step-2"), null, true) in Source

code

table-1

  1. If you drill into the Table cell you should be able to see the data and work from there.

table-2

answered Dec 22, 2020 by Gitika
• 65,910 points

Related Questions In Power BI

0 votes
1 answer

how can I connect my web api with Power BI Reports?

Go to Home > Edit Queries > ...READ MORE

answered Oct 18, 2018 in Power BI by Annie97
• 2,160 points
9,202 views
+2 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,030 points
151,963 views
0 votes
1 answer

How to connect to sap Hana database from power Bi?

Hi, Follow these steps to connect to data ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
7,061 views
+1 vote
3 answers

How to connect to oracle database from power Bi?

I use Devart ODBC drivers in order ...READ MORE

answered Dec 20, 2019 in Power BI by Tony
• 160 points
29,294 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
977 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,433 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,570 points
1,101 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,360 points
1,407 views
0 votes
1 answer

I have a web API with basic authorisation and username and password. How do i connect to it in Power BI?

Hey, @There, I found your query is quite ...READ MORE

answered Oct 29, 2020 in Power BI by Gitika
• 65,910 points
3,021 views
0 votes
1 answer

How to connect Github with power BI?

There are few steps which we need ...READ MORE

answered Nov 19, 2020 in Power BI by Gitika
• 65,910 points
986 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP