Power BI Google Calendar Connection to Read Events

[jpt1228]

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

[mkostkiewicz]

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.

[Anonymous]

HI @jpt1228,

I'd like to suggest you use web connector to get data from google api.

Reference link:

Google Calendar API

Google Calendar API: Get

Working with web services in Power Query/Excel and Power BI

Regards,

Xiaoxin Sheng

[jpt1228]

That is what I am doing. But not able to connect. I head read all those guides.

Thanks

[Anonymous]

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