Forum Discussion

nbrandborg's avatar
nbrandborg
Icon for Helper II rankHelper II
5 years ago
Solved

Transform 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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
    nbrandborg
    Icon for Helper II rankHelper II
    5 years ago

    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!