Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Proud to be a Super User!
Yes, there is. Here is an out-of-the-box solution providing exactly what you described: https://vidi-corp.com/salesforce-reports-connector-to-power-bi/
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
Proud to be a Super User!
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |