Google Sheets and Power Pivot

[flexinau]

Hi all,

Excel has powerful reporting capabilities using Power Pivot with its ability to add tables to Data Models.

Has anyone experienced or able to use these reporting capabilities in the cloud via Google Sheets?

Google Sheets is able to share Excel spreadsheets online to more than one user for simultaneous updates. This is a big deal when there are multiple users updating the file at the same time.

More specifically, has anyone able to make a Pivot Table work in Google Sheets when it is powered by two linked tables with relationships via Power Pivot?

Appreciate your feedback.

Cheers
Patrick