Python integration

[GianlucaM]

Hi,

i'm trying to integrate my scritp python in power BI, an easy one just to start, but i'm encountering difficulties
having this setting in powerbi

i'm trying to connect python 3.8 but it seems not able to load some libraries: when I run this basic script

I always have this message back with this error which i'm not able to solve

"Stack Trace:

Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: Python script error.

  File "PythonScriptWrapper.PY", line 20

    pip install matplotlib

        ^

SyntaxError: invalid syntax"

Thanks for any help on this,

regards
G

[GianlucaM · Accepted solution]

Hi,

no actually this wasn't the solution, i've been able to find a solution by myself. 

I had to run python (not an IDE) and load the libraries

Gianluca

[Anonymous]

Hi @GianlucaM ,

Please have a check.

If necessary, specify your local Python installation path in Detected Python home directories.

In the above image, the Python's installation local path is C:\Python. Make sure the path is for the local Python installation you want Power BI Desktop to use.

When preparing and running a Python script in Power BI Desktop, there are a few limitations:

• Only pandas data frames are imported, so make sure the data you want to import to Power BI is represented in a data frame
• Any Python script that runs longer than 30 minutes times out
• Interactive calls in the Python script, such as waiting for user input, halts the script’s execution
• When setting the working directory within the Python script, you must define a full path to the working directory, rather than a relative path
• Nested tables are currently not supported

Run Python Scripts in Power BI Desktop - Power BI | Microsoft Learn

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

Solved: Power BI Python ADO.NET: Python Script Error - Microsoft Power BI Community

Solved: Python integration error - Microsoft Power BI Community

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.