Power query and clean data without making change in the source, it has clear step by step process, you can apply same data cleaning steps on some new set of data that have same architecture by just one click, by clicking refresh. You can things in the graphic interface and it turn it into code. Best thing is power query is same in excel and Power BI Review collected by and hosted on G2.com.

Some it gets stuck while doing a step or while refreshing data from source and it mostly in case where source is in the web i.e. Sharepoint URL Review collected by and hosted on G2.com.