PowerBI Won't Open IDE for Python (Visual Studio)

[Anonymous]

I saw a similar post from the past but it was never resolved, I'm wondering if anyone else is running into similar issues.

I have installed PowerBI and Visual Studio Code, installed Python and Python extension for VS Code. VS code is set as default application for opening .py files. 

When I go to Python settings VS Code doesn't appear in drop-down as an installed IDE. When I ask PBI to use the default app for .py extensions or manually point to VS Code's executable, it still ignores the whole thing and just opens the built-in Python editor.

Am I missing something or this is a bug? 

Thanks 

[finchy]

I have the same problem, the reply marked as accepted solution is not a fix.

From what I have found, this appears to be a bug with the Power BI Desktop version that is installed from the Microsoft Store. A Power BI Desktop install that is downloaded from the website does not have this issue. I have been able to replicate this issue on two different devices using the store install. It seems that the Microsoft Store version has some kind of security/permission/environment limitation that does not allow running the exe, and so I think that is why the path is cleared when saving the IDE path, and does not allow the default app for .py files to launch correctly either. 

Is it possible to have a bug fix ticket created for this? Or at least warning message stating that setting an IDE is not supported with the store downloaded version? While the solution would be to download from the website directly, I do not have the permission to use installers for apps in my organization, and can only use the approved apps via the store.

[Anonymous]

The ultimate solution to this problem is for you to change the default py script execution program.
Make sure it's like the PY IDE, and change it to VSCode.

[v-cazheng-msft]

Hi, @Anonymous 

You can refer Run Python scripts in Power BI Desktop and Use an external Python IDE with Power BI. If it doesn't work, you can consider downloading Python from Python website and installing it.

Best Regards,

Caiyun Zheng

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

[Anonymous]

Latest supported version of Python is installed and I've already followed the steps in the documentation. It simply doesn't work.

[v-cazheng-msft]

Hi, @Anonymous 

Can you describe your configuration steps with more details? Does your setting for Python in Options looks like the following?

Best Regards,

Caiyun Zheng

[Anonymous]

Python scripts do run but IDE doesn't launch. I'm pointing it to VS Code executable as it doesn't appear on the detected IDE drop-down. 

[v-cazheng-msft]

Hi, @Anonymous 

Your configuration in Options is correct. Then you need click the arrow to enable VS Code. Have you operated like this?

Best Regards,

Caiyun Zheng

[Anonymous]

I don't see the arrow or syntax highlighting. Tried both in get data and Query Editor windows.

[v-cazheng-msft · Accepted solution]

Hi, @Anonymous 

You can try the following steps.

1 Select Python visual from Visualizations Pane to enable scripts visual

2 Drag a field into Python visual as values and then click the arrow to enable script in external IDE

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

I have the same problem, but the solution provided is not valid.

It seems that PowerBI is simply not able to accept the vs code installation path (which by the way is in the default path): after indicating the VS Code path and OK, if I reopen the Options it is again set to "Default OS program for files". PY", and of course it opens the other editor instead of Code.exe when I add a visual python.

Any ideas? Thanks in advance.

[Anonymous]

I'm having the same problem.

Have you found a solution yet?