topic Re: Python script error in Developer

Python script error

norazmanz — Sat, 03 Dec 2022 23:39:30 GMT

Hi all

I am trying to run a simple Python Script (tested in python environment) in PBI desktop Get Data:

import pandas as pd
import matplotlib as plt

df = pd.DataFrame({'Name':['Joe','Susan'],'Age':[24,25]})
print(df)

But get the following error:

Unable to connect

Details: "ADO.NET: A problem occurred while processing your Python script.
Here are the technical details: Access is denied"

I installed python in WindowApp folder which is restriced except for company admin. Wondering whether this is the issue? Anyone faced similar error and have a workaround? Aprpeciate it, thanks

Re: Python script error

Gengar — Sun, 04 Dec 2022 12:03:15 GMT

Hi @norazmanz ,

I installed python in WindowApp folder which is restriced except for company admin

According to my knowledge, It has a high probability of causing this problem.

Please try testing with an account that has access to this folder or move it to a folder that you have access to.

Hope this could help you!

Gengar

Re: Python script error

norazmanz — Mon, 05 Dec 2022 00:20:22 GMT

hi @Gengar

Thanks for replying. I would need to reinstall which is quite a pain since I have downloaded loads of libraries. Will update here after doing so.

Re: Python script error

norazmanz — Wed, 07 Dec 2022 05:48:43 GMT

Update: I have uninstalled and reinstalled Python in a new folder (which does not have restricted access) and also enable saving installation path in environment. Now it works!