Forum Discussion
Currency FX rates
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?
3 Replies
- tackytechtom
Most Valuable Professional
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 DocsUsing 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/ - tackytechtom
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/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
