Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
nbrandborg
Helper II
Helper II

Transform data with Python after import from SQL server

‎05-19-2021 03:54 AM

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

Labels:
Message 1 of 3
897 Views
0
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

‎05-19-2021 03:58 AM

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

Message 2 of 3
885 Views
0
2 REPLIES 2
amitchandak
Super User
Super User

‎05-19-2021 03:58 AM

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here
Message 2 of 3
886 Views
0
nbrandborg
Helper II
Helper II
In response to amitchandak

‎05-19-2021 06:18 AM

@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!

Message 3 of 3
831 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

View All