The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Dear Power BI & Python Experts,
I am trying to run Python code (Python Visuals) in Power BI.
I have anaconda downloaded and this is where I do my normal python analysis within Jupyter. I pointed my Python home director in Power BI to "C:\Users\myname\AppData\Local\Continuum\anaconda3"
No code at all will run. To test it I just threw in a basic ID column and hit run.
Any help would be greatly appreciated I have been researching for a while now and can't find a solution.
This is the following error I get:
Feedback Type: Frown (Error) Timestamp: 2019-10-18T19:31:46.8084395Z Local Time: 2019-10-18T14:31:46.8084395-05:00 Session ID: da4ed678-e1ce-4ffe-8af3-bce3b473a727 Release: October 2019 Product Version: 2.74.5619.621 (19.10) (x86) Error Message: Python script error. Traceback (most recent call last): File "PythonScriptWrapper.PY", line 2, in <module> import os, uuid, matplotlib File "C:\USERS\GCULP2\APPDATA\LOCAL\CONTINUUM\ANACONDA3\lib\site-packages\matplotlib\__init__.py", line 138, in <module> from . import cbook, rcsetup File "C:\USERS\GCULP2\APPDATA\LOCAL\CONTINUUM\ANACONDA3\lib\site-packages\matplotlib\cbook\__init__.py", line 31, in <module> import numpy as np File "C:\USERS\GCULP2\APPDATA\LOCAL\CONTINUUM\ANACONDA3\lib\site-packages\numpy\__init__.py", line 140, in <module> from . import _distributor_init File "C:\USERS\GCULP2\APPDATA\LOCAL\CONTINUUM\ANACONDA3\lib\site-packages\numpy\_distributor_init.py", line 34, in <module> from . import _mklinit ImportError: DLL load failed: The specified module could not be found.
@Anonymous ,
Have you installed matplotlib amd numpy package in anaconda?
Regards,
Jimmy Tao
@Anonymous Did you tested your Python script in Jupyter ? Is that working ? Please share the python test script that you are using.
Yes, Python visual in PBI requires atleast one data field (a dummy column will do).
Proud to be a PBI Community Champion
Yes so I can run scripts in Anaconda very easily and I have all the packages (matplotlib, Pandas, etc...) installed in my Anaconda environment.
I submitted a ticket with Microsoft so if we can figure it out I will post the solution here.
User | Count |
---|---|
71 | |
64 | |
62 | |
50 | |
28 |
User | Count |
---|---|
117 | |
75 | |
62 | |
54 | |
43 |