Forum Discussion
Connect data from Amazon AWS Services
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
Anonymous 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.