Forum Discussion

Shweta_1585's avatar
Shweta_1585
New Member
2 years ago
Solved

How to Python in power bi (csv file how to write dataset)

I am trying to upload csv, file in powerbi for python work but not able to import it.

Need Help

7 Replies

  • daircom's avatar
    daircom
    Icon for Resolver II rankResolver II
    2 years ago

    Hi Shweta_1585 ,
    Can you clarify a bit more what you are trying to achieve? Do you want to create a csv using Python and import it to Power BI? Or are you trying to use the output of Power BI with Python?

    • Shweta_1585's avatar
      Shweta_1585
      New Member
      2 years ago

      Hi, Actually I am trying to import csv file in power bi using python scripting but i am new for phython so not able to import the file properly to complete assignment. I need to give proper dataset address here I am stuck how to do it.

      Thanks.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Shweta_1585 ,

    Based on the description, try to use the following code.

    df = pandas.read_csv(r'path\to\your_file.csv')

    What’s more, it is not recommended to use python scripts to import data if you are new to python.

    You can just select the csv.

    You can also view the following documents to learn more information.

    Solved: PYTHON INTEGRATION WITH POWER BI - IMPORTING EXCEL... - Microsoft Fabric Community

    Run Python scripts in Power BI Desktop - Power BI | Microsoft Learn

     

    Best Regards,

    Wisdom Wu

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