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 before when running it directly in Power BI Python script. However, after following the artile, How to Get Started Using Python using Anaconda, VS Code, Power BI and SQL Server, which I find oneline, it now works. The problem now is that when I try to automate the Python script using schedule refresh Gateway connection, it pops up error again. Please see below for details. I am using personal gateway. I cannot find a solution online. Could anyone help with this? Thanks!

 

Failed to update data source credentials: ADO.NET: Python script error. C:\Users\becky.lam\Anaconda3\lib\site-packages\numpy\__init__.py:143: UserWarning: mkl-service package failed to import, therefore Intel(R) MKL initialization ensuring its correct out-of-the box operation under condition when Gnu OpenMP had already been loaded by Python process is not assured. Please install mkl-service package, see http://github.com/IntelPython/mkl-service from . import _distributor_init Traceback (most recent call last): File "C:\Users\becky.lam\PythonScriptWrapper_a418e530-37dc-4b01-9ce1-9ef57887a15a\PythonScriptWrapper.PY", line 2, in <module> import os, pandas, matplotlib File "C:\Users\becky.lam\Anaconda3\lib\site-packages\pandas\__init__.py", line 16, in <module> raise ImportError( ImportError: Unable to import required dependencies: numpy: IMPORTANT: PLEASE READ THIS FOR ADVICE ON HOW TO SOLVE THIS ISSUE! Importing the numpy C-extensions failed. This error can happen for many reasons, often due to issues with your setup or how NumPy was installed. We have compiled some common reasons and troubleshooting tips at: Please note and check the following: * The Python version is: Python3.9 from "C:\Users\becky.lam\Anaconda3\python.exe" * The NumPy version is: "1.20.3" and make sure that they are the versions you expect. Please carefully study the documentation linked above for further help. Original error was: DLL load failed while importing _multiarray_umath: The specified module could not be found. Hide details

5 Replies

  • 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?