Forum Discussion
Power BI with AWS
- Anonymous2 years ago
Hi powerbiexpert22 ,
Yes, you can use Power BI with the AWS ecosystem, including services like AWS S3, AWS RDS, and AWS Redshift. However, there can be challenges related to connectivity, security, performance, and cost optimization. For instance, setting up a fully functional and reliable Power BI Data Gateway can be complex. Also, dealing with massive and complex data, such as the AWS cost and usage report, can be challenging.
As for your second question, Power BI does allow you to select the region where your data is stored. The region is selected when you set up a new capacity in the Power BI service. You can find out in which region your data is currently located by logging into the Power BI service and selecting 'About Power BI’8. It’s important to review the data region before signing up for Office 365, Power BI, or other Microsoft services. So, if your AWS Redshift is hosted in the Europe region, you can indeed save your Power BI reports in the Power BI Service in the Europe region.
For more you may refer to:
Introduction - Using Microsoft Power BI with the AWS Cloud (amazon.com)
Multi-Geo support for Fabric - Microsoft Fabric | Microsoft Learn
Best regards.
Community Support Team_Caitlyn
Hi Anonymous
Can you share more details on how dealing with massive and complex data, such as the AWS cost and usage report, can be challenging?