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.
Hello, we use advanced currency management in SFDC to convert revenue from CAD to USD. Is there an easy way to pull this into Power BI?
Hi @jwb1081 ,
I apologise for not have added this: You need to install some python stuff beforehand:
Run Python Scripts in Power BI Desktop - Power BI | Microsoft Docs
Using Python in Power BI Power Query Editor - Power BI | Microsoft Docs
I hope these two links will help you. I will add them to the blog post, too.
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @jwb1081 ,
I am not sure whether this blog post is easier than your solution in place, but it describes a way to get exchange rates into Power BI via yahoo finance and a python script 🙂
Hope this helps!
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @tackytechtom.
I'm not a developer and unfortunately not familiar with Python. Below is the error I'm receiving...
DataSourceKind=Python
DataSourcePath=Python
Message=Python script error.
<pi>Traceback (most recent call last):
File "C:\Users\jon.bingel\PythonScriptWrapper_4974a5db-aca6-4446-85c9-b6a389ad0b07\PythonScriptWrapper.PY", line 2, in <module>
import os, pandas, matplotlib
ModuleNotFoundError: No module named 'pandas'
</pi>
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |