Forum Discussion

Dukezera's avatar
Dukezera
Frequent Visitor
4 years ago

Power BI - Power Query -Data manipulation in a dataframe already in Power Query

Is it possible to perform data manipulation of a table already connected in power query? All examples I saw using python, the script always imported a new dataset. However, I don't want to import a n...
Need Help
  • Dukezera's avatar
    Dukezera
    Frequent Visitor
    4 years ago

    No, I'm bringing using postgre connection. I want to use pytho to data manipulation

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Dukezera ,

       

      According to your statement, I think you want to do some transform by Python on data which has been uploaded into Power Query. 

      Power BI support you to do this. Install Python on your local machine , import data to Power BI and use "Run Python Script" in Power Query Editor.

      You may refer to the below offical blog to learn more details.

      For reference:

      Use Python in Power Query Editor

       

      Best Regards,
      Rico Zhou

       

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

      • Dukezera's avatar
        Dukezera
        Frequent Visitor
        4 years ago

        Yes, but how to use in a database/table already connected on power bi? 
        I dont want to import in Python/pandas. 

        I want to import for example in a postgres and use Python to manipulate the data.