Forum Discussion
Use python to transform data
Hi Guys,
I have a table and I need to do some tranformation using python script.
I know that it is possible to use python script on Power BI.
How can I do a table tranformation using python script?
Thanks
Hi Anonymous ,
About using Python to do transformations in power query, you can refer these documents and articles that could help you:
- Basics of Power BI Transformations with Python
- Use Python in Power Query Editor
- power-bi-how-to-use-python-with-multiple-tables-in-the-power-query-editor
- Transform Data in Power BI with R and Python
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
What transformation are you trying to do? Are you sure Python needed? Here is a video on getting started with Python if you really need it.
(9) Intro to Python in Power BI - YouTube
Pat
Hi Anonymous ,
About using Python to do transformations in power query, you can refer these documents and articles that could help you:
- Basics of Power BI Transformations with Python
- Use Python in Power Query Editor
- power-bi-how-to-use-python-with-multiple-tables-in-the-power-query-editor
- Transform Data in Power BI with R and Python
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi everyone. Need help. I have column with number of seconds (number type) and I need that big numbers (~32 000 000) transform to days, hours ... I allredy made it with DAX. But can't use this result to see averege time. I think python should help.
