Forum

PowerPivot connetio...
 
Notifications
Clear all

PowerPivot connetion to Salesforce

5 Posts
2 Users
0 Reactions
70 Views
(@bartkowiak)
Posts: 12
Eminent Member
Topic starter
 

Hi,

I´m looking for a way to connect PowerPivot directly to Salesforce, but I couldn´t find the data connection link. In Excel there is an option under Get Data->From Online Services -> From SalesForce.

Is it also possible in PowerPivot?

Thx.

Best regards, Christoph

 
Posted : 12/04/2019 8:28 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Christoph,

Welcome to the forum 🙂

You can use Power Query (not Power Pivot) to get the data (Data tab of the ribbon) 'from Online Services' > 'From Salesforce Objects' or 'From Salesforce Reports'. From Power Query you can load to the Power Pivot data model.

I hope that points you in the right direction.

Mynda

 
Posted : 12/04/2019 7:02 pm
(@bartkowiak)
Posts: 12
Eminent Member
Topic starter
 

Thank you

Christoph

 
Posted : 13/04/2019 3:11 am
(@bartkowiak)
Posts: 12
Eminent Member
Topic starter
 

Sorry,

one further question regarding connections. Do you know if it´s possible to connect SAP directly to Power Pivot or Power Query or Excel?

Nice weekend.

Chirstoph

 
Posted : 13/04/2019 4:48 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Christoph,

With Power Query you can connect to SAP HANA Databases.

Mynda

 
Posted : 14/04/2019 10:59 pm
Share: