Conclusion - Using Microsoft Power BI with the AWS Cloud


If you’re looking to use Microsoft Power BI Desktop, we generally find that customers start experimenting with the software on premises, connecting to data sources over the internet. While private connectivity options exist for using AWS VPN and Direct Connect, many customers have concluded that running Microsoft Power BI Desktop in Amazon WorkSpaces provides a better performing experience.

If you want to connect data sources in AWS to Microsoft Power BI Service, you should feel comfortable knowing that this is an established architectural pattern. You can install the Microsoft on-premises data gateway within an Amazon VPC and connect data sources such as Amazon RDS, Amazon Redshift, Amazon Athena, Amazon OpenSearch, and AWS Lake Formation seamlessly to the service.

If you plan on using Microsoft Power BI Report Server in AWS, there is also an established path forward. You can install the Microsoft Power BI Report Server within an Amazon VPC, close to AWS data sources, and there are connectivity options for both authors and report users.

If you want a solution that provides the same business outcomes, without the added complexity of installing, configuring, patching, and scaling self-managed BI solutions, we recommend Amazon QuickSight. This fully managed service combines all the required functionality in a simple web browser experience with pay-per-user pricing. There is nothing to install and no additional components are required.

Hopefully, this is just the start of your business intelligence journey with AWS. For additional resources to help you get started, see the Appendix: Microsoft Power BI supported AWS data sources.