Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
moe_elbohsaly
Helper I
Helper I

Power BI Integration with AWS RDS

I want to switch my on-premise connection to Amazon Relational Database Service (RDS). How to properly configure this on app.powerbi.com?

4 REPLIES 4
moe_elbohsaly
Helper I
Helper I

Do you wish to connect remotely and figure things out? I follow the GMT+2 timezone

Hi @moe_elbohsaly ,

 

If you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

v-tangjie-msft
Community Support
Community Support

Hi @moe_elbohsaly ,

 

To switch your on-premise connection to Amazon RDS and configure it on app.powerbi.com, follow these steps:

1.Install Npgsql, which allows .NET access to PostgreSQL. Follow the instructions in these links:

Power Query PostgreSQL connector - Power Query | Microsoft Learn

2.Connect to AWS over SSL
3.Download the AWS public key
4.Convert the key using SSL Converter (Current Certificate Type: Standard PEM, Convert to: P7B/PKCS#7)
5.Apply the certificate by importing it into the Trusted Root Certification Authorities on your local computer.
6.Test access from Power BI Desktop using the PostgreSQL connector.
7.To use it in Power BI Service, create a new data source in the Manage Gateways screen.

 

Please refer to the following documents for more information.

How To Connect Power BI to an AWS RDS SQL Server | by WCI Data Solutions | Medium

Connecting PowerBI to RDS PostgresQL on AWS | by Pallav Mathur | Medium

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

But what if my Aruroa cluster exists in a private subnet? @v-tangjie-msft 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors