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?
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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.