Select Column From Existing Table with Python

[Antonio_Gomez]

Hello Everyone!

I need some help, please.

I want to create a table from selecting only the column "Destination" of the table "Historical" using Python on the PBI.

My tables are in an SQL Server database with one name for the Server and other name for the database

[daXtreme]

@Antonio_Gomez 

Why do you have to use Python to do it? Is it not dead easy thru Power Query's native capabilities?

[Antonio_Gomez]

Hello @daXtreme Thanks for your interest,

My main goal is to clean that column. It contains information that needs standardization, so, I need to create an auxiliar table from that column and apply it after that some transformations.

Maybe, I could create that table with M in Power Query and after that use python.

[daXtreme · Accepted solution]

@Antonio_Gomez 

You certainly should use PQ to cleanse your data. On top of that, yes, you can use Python in PQ but given that PQ has so many capabilities and the M language that is so versatile... I would not even try to use Python 🙂 Just try to make use of what's already in there!