Connect to Google Calendar and Speedsheet RRS feed

  • Question

  • Hi,

    I want to connect to my shared Google Calendar and a Google spreadsheet in order to load their data to my existing Power Pivot data model. Sorry I know almost nothing about API. Can you please guide me? 

    Thanks for any suggestions


    Saturday, November 16, 2013 9:13 PM


  • Hi Konstantinos,

    We have not tried Google calendar but it is possible to connect to Google spreadsheets in Power Query and then import the data into Power Pivot. There are certain settings you would need to apply to your spreadsheet, such as publishing the spreadsheet and making it visible to those who have the link, as Power Query does not currently support the authentication required to access it through your account. Please let us know if you have any other issues.



    Tuesday, November 19, 2013 10:11 PM