How to read imported data with Python script?

[h4tt3n]

Hello folks,

I work professionally with Power BI and need a bit of help getting started using Python for data transformation. I already know how to run a python script inside Power BI.

What I have:

I've got a data table containing a UTC timestamp column.

What I want:

1. Read this column into a Python variable, probably a Pandas data structure.

2. Transform the timestamp from UTC to local user time using an IANA tz (I've already got the script for doing this).

3. Export or "print" the transformed data into the original table, deleting or overwriting the original values.

So, tldr: How do I read a table or column of imported data from power BI into a python variable, and how do I "print" or export the transformed data back into a PBI  table?

Cheers, and thanks in advance,

Mike

[Mariusz · Accepted solution]

Hi @h4tt3n 

Are you trying to do it in Power Query? if so chect this documetaition 
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-in-query-editor

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn