Forum Discussion
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
2. How often it refreshes and how can I create the limits of when it imports data and refreshes the vizualisations?
Thank you very much!
12 Replies
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 ZhangAnonymous Hey Lydia, Thanks for your great suggestion but I was unable to connect SQL Server to Power BI. Apparently, it had to be listed as one of the applications that Amazon AWS is working with.
Is there any alternative though? I've tried downloading the Data Gateway, https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/, but there was an error connecting to the server.
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?
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
Hello All,
It is possible to connect POWER BI desktop to DENODO (AWS)?
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.
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!
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!
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.
