Forum Discussion

JohnnyK's avatar
JohnnyK
Advocate II
5 years ago
Solved

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...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi JohnnyK 

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

     

    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

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi JohnnyK 

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

 

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

  • JohnnyK's avatar
    JohnnyK
    Advocate II
    5 years ago

    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.