Forum Discussion
Run R/Python scripts in PBI Power Query
Hi cmcknight,
Your screenshot looks like the New Power Query experience rather than the classic Power Query Editor.
Microsoft’s current documentation for R and Python still shows these commands in the classic editor under:
Transform -> Run R script
Transform -> Run Python ScriptYou can see that in the R in Power Query Editor guidance and the Python in Power Query Editor guidance.
I would first test the legacy editor:
File -> Options and settings -> Options -> Preview features -> clear New Power Query experienceMicrosoft documents that you can return to the legacy experience when the new Power Query UI is missing functionality needed for your workflow.
The current New Power Query limitations page does not specifically list R/Python scripts as a documented limitation, so I would use this as a diagnostic rather than assuming the feature has been removed.
If the buttons return in the legacy editor, that confirms it is related to the new UI.
If they are still missing there, then I would check:
File -> Options and settings -> Options -> R scripting
File -> Options and settings -> Options -> Python scriptingand make sure Power BI detects valid local R/Python installations.
For Python, Microsoft also requires pandas to be installed.
So I would troubleshoot it in this order:
switch to legacy Power Query
-> check whether the buttons return
-> verify R/Python installation paths
-> restart Desktop if needed
-> test againIf the commands only disappear in the New Power Query experience, I would submit that as feedback because it is not currently listed as a documented limitation.
AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.