cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RaulPBI Regular Visitor
Regular Visitor

How to connect google sheet to Power BI

Hi all:

 

I have developed a model linked with Google Drive, and have problems with data update.

 

Every month we do next:

 

- generate .csv with the same link

- then we open then in spreadsheet and generate the links in order to link to Power BI. The thing is that these links are not permanent (contrary to the csv), so every month we change them and there is no a complete automation.

- furthermore when I import data to Power BI in some columns the system adds 'commas' after some number columns.

 

Any idea?

 

Thank you in advance. 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-haibl-msft
Microsoft

Re: How to connect google sheet to Power BI

@RaulPBI

 

Do you have any other problem about this scenario?

 

Best Regards,
Herbert

View solution in original post

10 REPLIES 10
Microsoft v-haibl-msft
Microsoft

Re: How to connect google sheet to Power BI

@RaulPBI

 

You can publish the google sheet to web to get the excel link as following screenshot. Then get data in Power BI Desktop using the web connector with the excel link.

 

How to connect google sheet to Power BI_1.jpgHow to connect google sheet to Power BI_2.jpg

 

Please also vote on following idea to push the product team to make it to be a built-in connector in the future.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6656584-connectivity-to-google-sh...

 

Best Regards,
Herbert

 

Microsoft v-haibl-msft
Microsoft

Re: How to connect google sheet to Power BI

@RaulPBI

 

Does above suggestion help?

 

Best Regards,
Herbert

RaulPBI Regular Visitor
Regular Visitor

Re: How to connect google sheet to Power BI

Sure, that works. But, what happen when you update data in this file? Can you use the same link or you have to change it?

Microsoft v-haibl-msft
Microsoft

Re: How to connect google sheet to Power BI

@RaulPBI

 

You do not need to change the link and you can refresh the data by clicking Refresh in Power BI Desktop.

 

Best Regards,
Herbert

RaulPBI Regular Visitor
Regular Visitor

Re: How to connect google sheet to Power BI

I share the report on Service Power BI and schedule the update. I don't need to refresh whether I do that. I mean, the issue is that in order to update data in excel file and then maintain the same link to connect to Power BI, how I should proceed?

 

thank you for your comments Herbert

Microsoft v-haibl-msft
Microsoft

Re: How to connect google sheet to Power BI

@RaulPBI

 

If you get data from Google Sheet through Web connector in Power BI Desktop, then publish the reprot to Power BI Service. You only need to schedule refresh for it. Please refer to my screenshot below. Once the schedule refresh is triggered, the dataset will be refreshed. You do not need to do other thing like changing the link.

 

How to connect google sheet to Power B_1.jpg

 

Best Regards,
Herbert

Microsoft v-haibl-msft
Microsoft

Re: How to connect google sheet to Power BI

@RaulPBI

 

Do you have any other problem about this scenario?

 

Best Regards,
Herbert

View solution in original post

Ashwini123 Occasional Visitor
Occasional Visitor

Re: How to connect google sheet to Power BI

@v-haibl-msft

 

Hi, I am new to Power BI. 

 

I tried this method to connect to the Google sheet. 

But instead of getting the table data in the Power BI Navigator, I get a pop up dialog to download the Google sheet from my browser. Along with this, the table 0 looks like this.

 

Capture.PNG

With every refresh, I get a dialog box to let my browser download the Sheet.

 

Please advise on how to fix this.

plukacsi Regular Visitor
Regular Visitor

Re: How to connect google sheet to Power BI

I have the same issue

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,075)