Forum Discussion

sjl_74's avatar
sjl_74
Microsoft Employee
2 years ago
Solved

Python & R Missing From Power Query Editor.

Yesterday I recieved an update for PowerQuery.
This seems to have removed Python & R as an option.

 

Neither Python nor R appear in the Transform bar - Stopping me from adding Python queries..

When double clicking on existing Python functions, the' Run Python Scripts' window isn't displayed.

Is Python & R support being removed from the Power Query Editor?
& if not, is there a way for me to go back to the older Power Query Editor until it is added to the new version?

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi sjl_74 

    The python and r are displayed in the Power query editor.

    You can click 'Files->Option and settings->Option' then click 'R scripting' and 'Python scripting' to check that if your installations are right. If it still doesn't work, please consider to  reinstall Power BI Desktop.

     

    Best Regards!

    Yolo Zhu

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

     

     

    • sjl_74's avatar
      sjl_74
      Microsoft Employee
      2 years ago

      Hi Yolo Zhu....


      So, just to confirm:

      Python is working with .pbix dashboards created before the update.
      (So presumably it is setup correctly)

      I have also uninstalled, rebooted the sytsem & resintalled PowerBi (via the Microsoft Store)
      Unfortunatly it has had no effect

       

      • sjl_74's avatar
        sjl_74
        Microsoft Employee
        2 years ago

        Is there a way for me to revert back to the previous Power Query Editor?
        Or, are there any steps to can reccommend to ensure I have cmpletly removed all traces of PowerBi from my system after I uninstall?

  • sjl_74's avatar
    sjl_74
    Microsoft Employee
    2 years ago

    Hi Yolo Zhu,

     

    Thanks for replying.

    I do have Python setup in the options 
    (I've been using Python in Power Queries for the past few weeks) 

    Just to confirm - PowerBi documents which already contain Python script(s) continue to work.

    However, if I try to edit the script (via the advanced editor), any changes throw the error:

    (Note: Clicking continue does nothing)

    IF I try to paste code into a script (via the advanced editor), it throws the error:

     

    I did try uninstalling and reinstalling (installing from the Microsoft Store).
    It didn't make any difference.
    However, I did notice, when launching PowerBI after re-installation that the 'Recent' file list remained populated.
    (I don't know if there are any extra steps required to filly clear PowerBI from the system).
    I will try uninstalling & reinstalling again today.


    Thanks!