Forum Discussion
Helper IITransform data with Python after import from SQL server
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
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.
2 Replies
- amitchandak
Super User
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.
- 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!
