Forum Discussion
Data Cleaning
- 7 years ago
Hi Arcadis_PowerBI,
It's a little bit complex to implement data clean using power query, so I would recommend you to use extract your data into python pandas framework and do the data transform and clean in python. About how to implement python script in power query, please refer to this announcement: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/#python.
Regards,
Jimmy Tao
Hi Arcadis_PowerBI,
It's a little bit complex to implement data clean using power query, so I would recommend you to use extract your data into python pandas framework and do the data transform and clean in python. About how to implement python script in power query, please refer to this announcement: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/#python.
Regards,
Jimmy Tao