My python connection was working but it stopped today and keep on receiving this error message:
DataSource.Error: ADO.NET: A problem occurred while processing your Python script. Here are the technical details: Process must exit before requested information can be determined. Details: DataSourceKind=Python DataSourcePath=Python Message=A problem occurred while processing your Python script. Here are the technical details: Process must exit before requested information can be determined. ErrorCode=-2147467259 ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonUnexpectedException
Have installed Python through Anaconda? That's most likelly the problem. I installed python 3.6 on its own and was able to integrate python script into PBI. Then I installed python 3.7 through Anaconda and got similar error for the same script that gave me no issues previously. I repointed PBI to the 3.6 interpreter and it runs fine again. So the issue is either with python 3.7 or with how it is managed by Anaconda. My guess is it's Anaconda and hence the irony that I went for it for convinience...
Since PBI is giving the table as an input to your python step in the form of pandas.DataFrame, you need to have pandas installed on your computer, even though your script doesn't use it. Power BI needs to have access to the library in order to evaluate your code and pass inputs into it.