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 21, 2020 in Power BI by Rajiv
• 8,880 points
85 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 21, 2020 by Gitika
• 65,870 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,200 points
6,525 views
+3 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
• 32,930 points
57,663 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
• 32,930 points
4,086 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
13,840 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,150 points
332 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 21, 2018 in Power BI by nirvana
• 3,150 points
1,473 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,550 points
447 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,310 points
498 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,870 points
581 views
0 votes
1 answer

How to connect Github with power BI?

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

answered Nov 18, 2020 in Power BI by Gitika
• 65,870 points
96 views