none
Connect to Google Calendar and Speedsheet

    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

    Konstantinos

    Saturday, November 16, 2013 9:13 PM

Answers

  • 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.

    Thanks,

    Theresa

    Tuesday, November 19, 2013 10:11 PM