Forum Discussion

ashwini_bora's avatar
ashwini_bora
Regular Visitor
4 years ago
Solved

Importing data in Snowflake using Python script

Hi- I am trying to import the data from Snowflake DB using the python script in Power BI and want to create reports using Python provided packages.   The complete script works well on Python IDE (S...
Need Help
  • ashwini_bora's avatar
    ashwini_bora
    4 years ago

    Thank you for your response..

    As I had mentioned before, my Python version and execution is working fine.

     

    I was able to resolve the issue by invoking the Power BI app from Python environment from Anaconda command prompt using below-

     

    (python37) C:\Users\<myuser>\AppData\Local\Microsoft\WindowsApps>PBIDesktopStore

     

     

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi ashwini_bora ，

Do you know what version of Python your Anaconda environment is using? It seems will running into issues importing packages with 3.6 and 3.7.This error is due to VS not activating the conda environment before launching the python process.

Try to create a new conda env with Python 3.5:

conda create -n py35 anaconda python=3.5

Then pip installing relevant packages (I had issues with PowerBI recognizing conda installs):

 

conda activate py35
pip install matplotlib
pip install pandas

 

After this is complete, you need to point PowerBI to the new env.

 

Including steps for those less familiar:

File -> Options and Settings -> Options -> Python Scripting

 

Then add the Path to your new Env. Mine looks like:

"C:\ProgramData\Anaconda3\envs\py35"

 

details refer: 

https://developercommunity.visualstudio.com/content/problem/362404/importerrordll-load-failed-the-specified-module-co.html

https://docs.snowflake.com/en/user-guide/python-connector-example.html 

https://addendanalytics.com/blog/snowflake-dwh-connecting-to-python/ 

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien