Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hello, I have been trying to connect to a google calendar to import events into my data model. I have created an API key and have the URL but when I paste it outside of the API explorer it doesn't work.
GET https://www.googleapis.com/calendar/v3/calendars/*******%40gmail.com/events?fields=accessRole%2CdefaultReminders%2Cdescription%2Cetag%2Citems%2Ckind%2CnextPageToken%2CnextSyncToken%2Csummary%2CtimeZone%2Cupdated&key={YOUR_API_KEY}
I can't seem to find any sites that have instructions to connect to the google calendar.
Thanks
Hi
I;m starting with programing and I nedd a help.
Can someone give me instructions (step-by-step) how to connect google calendar events to Power BI? I want to create live connection to see events from selected date range on the maps.
When someone will add an event on google calendar with location I want to see it in Power BI on maps.
Thank you in advance.
HI @jpt1228,
I'd like to suggest you use web connector to get data from google api.
Reference link:
Working with web services in Power Query/Excel and Power BI
Regards,
Xiaoxin Sheng
That is what I am doing. But not able to connect. I head read all those guides.
Thanks
Hi @jpt1228,
Based on test, it seems like power query not support use oauth on google calendar api, maybe you need to consider to invoke api key to work through this issue.
Regards,
Xiaoxin Sheng
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!