Forum Discussion
How to connect google sheet to Power BI
2023 update - the method below is no longer required, the native connector to Google Sheets is generally available. This supports Google authentication, so the data no longer needs to be public.
https://learn.microsoft.com/en-us/power-query/connectors/google-sheets
**** BELOW IS NOW OUT-OF-DATE ****
The easiest way is to Get Data / From Web, then enter the URL to your google sheet, with "&output=xls" on the end, e.g.
http://spreadsheets.google.com/pub?key=r1hlZB_n1rpXTij11Kw7lTQ&output=xls
PBI then analyses the resulting Excel file, showing the tabs as tables , which you can edit and manipulate.
how do I get a developer id from google?
Most Valuable ProfessionalI have the basic process here in my post. https://tumbleroad.com/2016/07/07/free-marquee-google-sheets-template/ Do not use my sample developer id as this will not allow you to connect to your data.
However, this is the latest Google docs on the process: https://developers.google.com/identity/sign-in/web/devconsole-project Unfortunately there are no screenshots to walk you through this process. If you use the terms from the process above on getting the ID process and the updated doc link, you should be able to navigate through the new Google UI. I'm putting this on the backlog for update.
Treb Gatte | MVP | TumbleRoad.com | PowerBICertification.com