Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Errow when scheduling refresh for Python script in Power BI

Hi all,   Hope to get some advice with Power BI schedule refershing Python script.   I can run the Python script in Power BI successfully. I am using Anaconda environment and I do have issue befo...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Which version of Python your Anaconda environment is using? Try to create a new conda env with Python. 

Then pip installing relevant packages:

 

conda activate py

py -m pip install matplotlib

py -m pip install pandas

 

After finishing it, you need to point Power BI Desktop to the new env following steps :File -> Options and Settings -> Options -> Python Scripting. Then add the Path to your new Env, looks like: "C:\ProgramData\Anaconda3\envs\py".

 

Reference:

Python visualizations in Power BI Service

Configure scheduled refresh - Power BI

 

I have also found a similar post, please refer to it to see if it helps you.

ADO.NET error trying to run Python Script in PowerBI 

  • My PowerBI points to my Python distribution installed in C:\Python (yours most likely points to Anaconda).

 

If I have misunderstood your meaning, please provide a screenshot with the errors.

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Polly,

     

    I downloaded the latest Anaconda distribution a few days ago so I suppose I am using Python 3.9. 

     

    I have created a new env called powerbi_env and have added the path to the new env as shown below. I added the pandas, matplotlib, numpy packages through the Anaconda navigator (also shown below). It could be run using Power BI desktop without issues. However, when I try to use the personal gateway to automate it, an error pops up as shown in the below first screencap. It seems the gateway cannot connect to the most new environment? Any ideas what I should do?