Forum Discussion

icassiem's avatar
icassiem
Post Prodigy
1 year ago

PBI Connecting to AWS Read Replicas (MYSQL, PostgreSQL, MS-SQL)

Hi,

 

I need help please

I have aws read replicas (MYSQL, PostgreSQL, MS-SQL) i need to connect to, the devops team are opening up the vpc ports for pbi and desktop connectivity. How in desktop and services  do i connect to these RDS?

 

Secondly, the AWS S3 Gateway would that be as simple as a web connection?

 

Please any ideas

Regards

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, icassiem 

    Thanks for the reply from lbendlin  please allow me to provide addition:

    To connect Power BI to AWS Read Replica, download and install the Microsoft On-Premises Data Gateway on an Amazon EC2 instance in your VPC. This gateway will help you establish a secure connection between Power BI and your AWS RDS instance. Once installed, configure the gateway with your Power BI credentials. This will allow the gateway to establish outbound connectivity with Microsoft Azure Service Bus.
    Then connect to the RDS instance. Use the MySQL connector in Power BI. Enter the server name (the endpoint of your RDS instance), the database name, and your credentials. Install the Npgsql data provider for PostgreSQL. Then use the PostgreSQL connector in Power BI to provide the necessary connection details. Use the SQL Server connector in Power BI. Enter the server name, database name, and your credentials. You can check the following links:

    Connecting the Microsoft Power BI service to AWS data sources - Using Microsoft Power BI with the AWS Cloud (amazon.com)

     

    Connecting Power BI to AWS RDS PostgreSQL - Saurabha Joglekar

     

    To connect to AWS S3, you can use the web connector, in Power BI Desktop, go to Get Data > Web. Enter the S3 URL and provide your AWS credentials when prompted.

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

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

    • icassiem's avatar
      icassiem
      Post Prodigy
      1 year ago

      Thank You Anonymous , lbendlin 

       

      1. This is my concern with AWS RDS Replicas and S3, I dont have an EC2 instance at my disposal. Are there no other options?

      2. The S3, is it a case of getting the URL from AWS S3 buckets - but can i then query the S3 buckets like Athena does in Powerquery?

      3. I dont have an integration storage level, meaning i only view data via dbeaver and pbi in their seperate schema. Thinking out loud, is there a way in Power/PBI  i can query accross RDS perhaps publish all the RDS Schema and tables to PBI service and i can then connect via DBeaver/tool to able service queries accross datasets?

       

      Thank you so much, any help is much appreciated