Forum Discussion

skoalit's avatar
skoalit
Regular Visitor
9 years ago

Connect data from Amazon AWS Services

Hi I am new at this, but I would like to know how I can:    1. Connect live data from Amazon AWS Services (right now the crawler dumps the data on Amazon S3 as zip files), or even to an SQL server ...
Need Help
skypurplecloud's avatar
skypurplecloud
New Member
5 years ago

Hi.  If you are still having issues, please reach out and I can try to offer some advice about connecting external services into AWS.

 

I come from AWS background, so if you need assitance with secruity groups, routing or network configurations (this is usually the main stumbling block), I can attempt to help you out.

 

This should be fairly straighforward if you can see the AWS data source from the PowerBI environment.

 

Regards,

Roy.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi skypurplecloud ,

     

    I am having the reverse issue - I'm having trouble accessing my AWS files from Power BI so that I can set up transforming my daily data feeds. Would you be able to assist?

     

    Thanks!

  • skaranth10's avatar
    skaranth10
    Helper I
    5 years ago

    Hi skypurplecloud ,

    I am currently facing issues trying to connect Power BI to the AWS database as well. Been trying to read various articles on how this is being done, but I am not able to connect to the database. Any help would be appreciated! 

     

     

    • PhilipTreacy's avatar
      PhilipTreacy
      Super User
      5 years ago

      Hi skaranth10 

      It's best to start a new topic and explain in detail your issue there.

      What exactly is the problem?  What exactly are you trying to connect to?  AWS API?  SQL on AWS?  Amaxon S3?  Are you receiving error messages?

      Phil

      If I answered your question please mark my post as the solution.
      If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

      • skaranth10's avatar
        skaranth10
        Helper I
        5 years ago

        Hi PhilipTreacy ,

        I am trying to connect to the SQL on AWS. I have tried the Redshift Connector, but couldn't successfully connect. I get the error message as 

        "Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection refused (0x0000274D/10061)
        Is the server running on host "ec2-34-215-220-108.us-west-2.compute.amazonaws.com" (34.215.220.108) and accepting
        TCP/IP connections on port 5439?"

         

        Is Redshift the best way to connect? Do you recommend any other means? 

         

        Regards