PowerBI/Python error

[Anonymous]

I had this python working and then make some changes to try to troubleshoot with an colleague and now mine won't work.

The error:

ADO.NET: Python script error. Traceback (most recent call last): File "PythonScriptWrapper.PY", line 14, in <module> import nltk File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\site-packages\nltk\__init__.py", line 149, in <module> from nltk.translate import * File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\site-packages\nltk\translate\__init__.py", line 23, in <module> from nltk.translate.meteor_score import meteor_score as meteor File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\site-packages\nltk\translate\meteor_score.py", line 10, in <module> from nltk.stem.porter import PorterStemmer File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\site-packages\nltk\stem\__init__.py", line 29, in <module> from nltk.stem.snowball import SnowballStemmer File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\site-packages\nltk\stem\snowball.py", line 29, in <module> from nltk.corpus import stopwords File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\site-packages\nltk\corpus\__init__.py", line 66, in <module> from nltk.corpus.reader import * File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\site-packages\nltk\corpus\reader\__init__.py", line 105, in <module> from nltk.corpus.reader.panlex_lite import * File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\site-packages\nltk\corpus\reader\panlex_lite.py", line 15, in <module> import sqlite3 File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\sqlite3\__init__.py", line 23, in <module> from sqlite3.dbapi2 import * File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\sqlite3\dbapi2.py", line 27, in <module> from _sqlite3 import * ImportError: DLL load failed: The specified module could not be found.

PowerBI (May 2020)

conda: version 4.8.3 with

Python version 3.8.3.final.0

Package Version
---------------------------- -------------------
certifi 2020.12.5
cffi 1.14.4
chardet 4.0.0
click 7.1.2
cryptography 3.3.1
cycler 0.10.0
idna 2.10
joblib 1.0.0
kiwisolver 1.3.1
matplotlib 3.3.4
msal 1.8.0
nltk 3.5
numpy 1.19.5
Office365-REST-Python-Client 2.3.1
pandas 1.1.5
path 15.1.0
path.py 12.5.0
Pillow 8.1.0
pip 20.3.3
pycparser 2.20
PyJWT 1.7.1
pyparsing 2.4.7
python-dateutil 2.8.1
pytz 2020.5
regex 2020.11.13
requests 2.25.1
setuptools 52.0.0.post20210125
six 1.15.0
textblob 0.15.3
tqdm 4.56.0
unicodedata2 13.0.0.post2
urllib3 1.26.3
wheel 0.36.2
wincertstore 0.2
xlrd 1.2.0

[Anonymous]

I uninstalled and reinstalled anaconda and miniconda.  I did not change the file itself.  I followed the same steps I did before but am still getting the same error.  I have tried pip install pysqlite3 and also manually adding sqlite3.dll to the DLLS files. I still get the same error.

[PhilipTreacy]

Hi @Anonymous 

What changes did you make to result in these errors?  Do you have a backup of the file before you changed it, just use that copy?

This line

File "C:\Users\katemalter\Miniconda3\envs\ABA_env\lib\sqlite3\dbapi2.py", line 27, in <module> from _sqlite3 import * ImportError: DLL load failed: The specified module could not be found.

seems to indicate that perhaps the sqlite package isn't installed in Python.  It's not listed in the list of packages you've posted.

Check if it is and install if necessary.

Regards

Phil

[Syndicate_Admin]

Is there a solution for this?

Getting the same issue

Regards
Diego