Forum Discussion

jpt1228's avatar
jpt1228
Icon for Responsive Resident rankResponsive Resident
8 years ago

Power BI Google Calendar Connection to Read Events

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

Need Help
Show and Tell

4 Replies

    • jpt1228's avatar
      jpt1228
      Icon for Responsive Resident rankResponsive Resident
      8 years ago

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

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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

  • mkostkiewicz's avatar
    mkostkiewicz
    New Member
    4 years ago

    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.