cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohnnyK
Advocate I
Advocate I

Python to read and work on Salesforce report

Good day.

 

I'm pulling a report from Salesforce.com into Power BI desktop. Then I want to use Python script work on this Salesforce report (to produce a data frame for visuals).

 

How can I used Python to read the imported Salesforce report?

 

Thank you.

 

Here shows a way when Python to read a local Excel file, and I'm wondering what's the way to use Python to read Salesforce report.

https://community.powerbi.com/t5/Desktop/PYTHON-INTEGRATION-WITH-POWER-BI-IMPORTING-EXCEL-TO-POWER-B...

1 ACCEPTED SOLUTION
PhilipTreacy
Super User III
Super User III

Hi @JohnnyK 

In the Power Query editor you can click on Run Python Script from the Transform section of the Ribbon

pyth.png

 

You need to have Python installed on your PC for this to work.

 

Any reason you are using Python for this?  Can't you do whatever you need just by using Power Query?

 

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
PhilipTreacy
Super User III
Super User III

Hi @JohnnyK 

In the Power Query editor you can click on Run Python Script from the Transform section of the Ribbon

pyth.png

 

You need to have Python installed on your PC for this to work.

 

Any reason you are using Python for this?  Can't you do whatever you need just by using Power Query?

 

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

@PhilipTreacyHi Philip, thank you for your reply!

 

The visual I need requires part of pivot table (a few line of pivot table, together with some 'manual' calculated rows) produced from the Salesforce report imported, so I am thinking Python might help in such case.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors