Connecting Google sheets with Power BI

[Kulasekaran]

Hi,
I am new to Power BI community. I am buliding a BI Dashboard taking data from Google sheet. What I have done is connect google sheets to excel and taking data for dashboard from Excel file. Just wondering what is the best possible way to connect to Gsheets to Power BI?

[Kulasekaran]

Hi @tackytechtom,
Thanks for your solutions. This works good for me

[tackytechtom · Accepted solution]

Hi @Kulasekaran ,

There should be a google sheet connector that you can use:

Power Query Google Sheets connector - Power Query | Microsoft Docs

Here anoither link showing a more detailed way of connecting google sheet to PBI:

How to connect Power BI to Google Sheets? - Data and Marketing Attribution Modelling | Windsor.ai

And lastly a rich thread from this community forum, where you might get a few extra information:

Solved: How to connect google sheet to Power BI - Microsoft Power BI Community

Hope this helps! 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/