Currency FX rates

[jwb1081]

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? 

[tackytechtom]

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/

[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/

[jwb1081]

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