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 new dataset, I want to use one that I've already started dealing with in Power Query.

Need Help

4 Replies

    • 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.