This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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
@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
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 37 | |
| 28 | |
| 28 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 69 | |
| 38 | |
| 32 | |
| 28 | |
| 24 |