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

Re: How to connect google sheet to Power BI

Should this be working as well with Power BI Report Server?

 

Best Regards

PowerBI_AB Frequent Visitor
Frequent Visitor

Re: How to connect google sheet to Power BI

hey thanks, can we connect


@ImkeF wrote:

 I've used this custom connector recently and it worked just fine:

https://www.thebiccountant.com/2017/09/24/custom-connector-import-google-sheets-oauth2-powerbi/

 



google sheets linked to company id with power bi?

Super User III
Super User III

Re: How to connect google sheet to Power BI

Hi @asmarezgui ,

you can publish the report also on the report server, but you cannot schedule a refresh unfortunately, due to current limitations with OAuth: https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh  

 

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark my post as a solution. Thanks!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Highlighted
Super User III
Super User III

Re: How to connect google sheet to Power BI

Hi @PowerBI_AB ,

I don't understand what you mean with "linked to company id " (I'm not very familiar with GoogleSheets actually)

 

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark my post as a solution. Thanks!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




kuldeep Visitor
Visitor

Re: How to connect google sheet to Power BI

Thank You!

 

It's working.

MWinter225 Member
Member

Re: How to connect google sheet to Power BI

kaungmyataung Occasional Visitor
Occasional Visitor

Re: How to connect google sheet to Power BI

Another way is to make use of PowerBI python script feature. (Note : Better Privacy, IMHO)


1. Set up python script to connect to Google Sheets (https://towardsdatascience.com/accessing-google-spreadsheet-data-using-python-90a5bc214fd2) (Note: You need to enable Both Google Drive and Google Sheet)
2. Use that python script in PowerBI as connector. ( https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts ) (Need a bit modification such as pandas) Note: Make sure you install required python library such as "pip install pandas" etc

 

Below is sample of my script

 

import gspread
from oauth2client.service_account import ServiceAccountCredentials
import pandas as pd
from pandas.io.json import json_normalize

scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']
creds = ServiceAccountCredentials.from_json_keyfile_name('C:\\Users\\USER\\Downloads\\YourServiceAccountJSONFile.json', scope)
client = gspread.authorize(creds)
sheet = client.open('GoogleSheetFileName').sheet1
data= sheet.get_all_records()

df = json_normalize(data)
print(df)

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors