Use python to transform data

[Anonymous]

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

[IvanSinelnyk]

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. 

[v-yingjl · Accepted solution]

Hi @Anonymous ,

About using Python to do transformations in power query, you can refer these documents and articles that could help you:

1. Basics of Power BI Transformations with Python 
2. Use Python in Power Query Editor 
3. power-bi-how-to-use-python-with-multiple-tables-in-the-power-query-editor 
4. 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.

[mahoneypat]

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