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

[Shweta_1585]

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

[v-jiewu-msft · Accepted solution]

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.

[Shweta_1585]

Thank you so much its helpful.

[Shweta_1585]

Hi, I am trying but not getting proper solution

[Shweta_1585]

This message showing while importing the file. Can you help me to understand this.

[v-jiewu-msft]

Hi @Shweta_1585 ,

Based on the description, you need to install python packages.

What’s more, only pandas data frames import, so make sure the data you want to import to Power BI is represented in a data frame.

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.

[daircom]

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]

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.