Transform data with Python after import from SQL server

[nbrandborg]

Hi all,

I'm retrieving data from an SQL server for my Power BI Dashboard, but I have the need of transforming the import the SQL server gets me to something more useful for the display of the data. Is it possible to apply a python script to an already-imported SQL dataset?

Kind regards
Nichlas

[amitchandak · Accepted solution]

@nbrandborg , I can suggest to you the way to test, I have not tried that. Refer to my video where I have shown how to bring data using python. bring the SQL server data using Python and then do data transformation, before you return the dataset.

https://www.youtube.com/watch?v=5D0BkNsu5CM

[nbrandborg]

@amitchandak , thank you for refering to your video. I managed to pack the "SQL" import into the Python script, so it did it all together. Thank you for your help!