Forum Discussion
How to Python in power bi (csv file how to write dataset)
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.
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.
Thank you so much its helpful.
Hi, I am trying but not getting proper solution
This message showing while importing the file. Can you help me to understand this.
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.