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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi skoalit,

Do you want to connect to SQL Server in Amazon AWS from Power BI? If that is the case, in Power BI Desktop, you can use Amazon Redshift connector to connect to the instance. When you choose to Load data from Power BI Desktop Navigator , you'll prompted whether to use Import or DirectQuery mode to load the data. For more information, please review this article. After you import data from  Amazon AWS to Power BI Desktop,  you can create reports in the desktop, then publish the Power BI Desktop file(PBIX file) to Power BI service.

In Power BI Service, you can set schedule refresh for your dataset, in order to set how often it refresh your dataset, you would need to configure on-premises gateway and add Amazon AWS data source under the gateway. For more details, you can review this article.

There is also a similar thread for your reference: https://community.powerbi.com/t5/Service/Power-BI-and-SQL-Server-in-the-AWS/td-p/54057 .



Thanks,
Lydia Zhang

skoalit's avatar
skoalit
Regular Visitor
9 years ago

Anonymous Hey Lydia! Thank you very much for answering! 

 

I tried all the links that you recommended, and download and installed the gateway. however i was unable to connect the server as power bi could not point to aws. 

 

Is there an alternative way? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi skoalit,

    What is the error message do you get? Have you connected to the SQL Server instance in Power BI Desktop?

    Another possible option is to create a ODBC data source for SQL Server on AWS, then connect to the ODBC data source in Power BI Desktop.

    Thanks,
    Lydia Zhang