Data shaping in PowerBi

[pedroradwan]

Hi guys, I used to use Alteryx in my last job as a automation tool for cleaning/reshaping data. I'm new to PowerBi and not sure if it is able to do a similar task. I extract a report from my finance system, but I need to input it in a diferent format at our internal spreadsheets. It takes me hours to re-organize all the data... I need to move cells to different areas of the spreadsheet, and also delete a good part of the data located in the report. Is there a way of automating this process with powerbi or should I try another software? 

Thanks 

[amitchandak]

@pedroradwan , You can use power query for that

Power BI: Power Query Functions one must know
: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=36407s

Power BI - Cheat Sheet: Power Query Functions one must know
https://amitchandak.medium.com/cheat-sheet-power-query-functions-one-must-know-a8531b6e321a

Power Query Table Functions: https://www.youtube.com/playlist?list=PLPaNVDMhUXGalVK1yOQ8hV2kWTNsZW5Gq

Power Query DateTime Functions: https://www.youtube.com/playlist?list=PLPaNVDMhUXGZdm-2DIMrS54Z2J0TAxj0X

Power BI List Functions: https://www.youtube.com/playlist?list=PLPaNVDMhUXGbkShvXwEedw-cH3QBYhwvO