I was wondering if it was possible to use the (older) Power Pivot that had a SalesForce Datasource.
And publish it to SharePoint Online ?
Step 1. Connect to SalesForce using Power Query
Once the data source is filtered, formatted, …
Safe the Excel file… it stores automatically the data as a Power Pivot Data source.
Step 2. Create a Report Library
In your O365 SharePoint Online create a Report LibrarySs
Step 3. Save the file to the Library
Step 4. Next Create a Web Part Page
And add a Business Data WebPart
Point to the Excel in the Report Library.