Python Personal Gateway Credential Error

[AmyMisa]

Hello, 

I'm hoping someone can support me, as I have seen a few people on various forum posts discuss the same issue (however unfortunately without any solutions). Such posts as: https://community.powerbi.com/t5/Issues/Python-personal-gateway-credentials/idi-p/952729/page/2#comm...

As far as I can tell, everything is set up correctly, yet Python doesn't want to connect. The error suggests I don't have it installed, which I do and the Python script runs fine in PBI Desktop. The error then suggests I should provide the file path but as you can see it is greyed out - Has anyone struggled with this before and managed to fix it?

[Anonymous]

Hi  @AmyMisa ,

According to research, a similar issue has been reported internally,(ICM#: 315994430).

As suggested by ICM, you can try:

Looks into the PythonSettings.xml under C:\Users\<user_name>\AppData\Local\PowerBIScripting to determine the Python process location. The PythonHomeDirectoryOverride can be updated to point to the correct Python install folder :

<?xml version="1.0" encoding="utf-8"?>
<PythonSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <PythonHomeDirectoryOverride>C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\SHARED\PYTHON37_64</PythonHomeDirectoryOverride>
  <PythonOutputDirectoryOverride />
  <PythonEditorPathOverride />
  <PythonEditorTypeOverride>None</PythonEditorTypeOverride>
</PythonSettings>

Note, it's possible to run the gateway as a different user. Make sure the settings file is updated in the app data folder for that user.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AmyMisa]

Hi @Anonymous Thank you! 🙂  I was really hoping this would be it!! Unfortunately, the location in that file is the true location of my python install so there was nothing for me to change /: