1) nope, it's a 100% self service tool, no outside assistance needed.
2) PowerBI uses AWS just fine, you may need a gateway depending on how you expose your AWS DB for external access, but that'd be true of any tool connecting to it.
3) why an expert? Here's the API spec, it's not hiding ...