Some obvious differences: PowerBI is priced per user, so it can get expensive fast (assuming you need the pro features). Also, there doesn't appear to be a cloud version of PowerBI so you'd be managing it yourself. PowerBI doesn't support AWS Redshift or Aurora. And unless I'm mistaken, PowerBI desktop is Windows-only.