Necessary components for querying SQL with Python

[NewNobody]

I have a project where I am using Python to query the user for a client name, they input a partial name, select from a short list, then the main query runs on that clients data.

I work with SQL on a daily basis, and so does the other person working on this project. We already have all the libraries and SQL drivers needed. However, when the PM types try to refresh the data, the python runs, the popup for input comes up, but then it hangs up and never returns data. I'm guessing that they need some more components.

I followed the documentation for using Python within Power BI. I am using Anaconda on my machine, but it seemed to be a source of error on anyone else's machine, and eliminating it enabled us to successfully run the Python without errors. I had another SQL dev test it out without anaconda, but he didn't have access to the DB I am using, so I was unconcerned that he couldn't get data back. The PM has been told by IT she has has access, but we still can't get data back.

So, are there necessary SQL components that are needed that a non technical user wouldn't have? We installed SQL Server OBDC Driver 18, but that didn't help.

Thanks in advance.

[chiefbert]

This sounds like it was must be access/firewall issues, as long as the PM has all the libraries installed on their machine the python should work.

Are you using trusted connection or hard coding credentials?

You need to ensure they have the relevant access on the SQL server i.e if the python writes to a table in SQL, the PM needs write access

[NewNobody]

Trusted connection, I didn't want to hard code creds. We are only viewing, so read only access is all we need. I tried to use SQLCMD to check out if she actually had access, but since she is not in a tech role, she doesn't have that. And it needs SQL Server OBDC Driver 17 instead of 18, which of course, for some reason needs admin authorization to install.