I don't know if this is appropriate for here but does anyone have any experience with PowerQuery.
I would like to connect to a SQL database and build reports. I dont know SQL language so maybe PowerQuery might help.

I would like to be able to directly build the report or extract right in excel so I can automate certain processes. Rather than using a secondary system to extract the data..manipulate it and then paste it into excel

Is powerquery the way to go? Any comments would be appreciated.

Thank you.