Latest Enterprise DNA Initiatives

R script in Power BI Using A cloud Instance (AWS)


I would like to know how to run powerBi , R script using the R instance in Amazon Web Server

Is this possible


I’m certainly not a R whiz, but hopefully theses links point you in the right direction.




This is a super interesting question. I’m not sure whether it’s possible or not, but will be glad to dive into this question this evening after work. In the meantime, I’m looping in Enterprise DNA Poweruser @bradsmith who may know the answer offhand.

  • Brian

Ohhh boy… I would need to know exactly how you’d like to use the R instance in AWS. I’m assuming you’re referring to an Amazon EC2 R instance? Are you hoping to import the data, use a direct query, or include it in a visual?

Edit - Here’s the recommended configuration:

  • Install a Microsoft On-premises data gateway on an Amazon EC2 instance in the private subnet where you have all your data sources.
  • Configure the subnet to to route requests through an Amazon VPC NAT gateway in a public subnet.
  • Note: If you are going to need a highly available implementation I’d suggest adding cluster.
1 Like


It would be interesting to hear more about your use case and what you’re trying to accomplish, to see whether a simpler solution like R Studio Cloud might be workable.

– Brian

Hi @gbortz27, we’ve noticed that no response has been received from you since the 17th of February. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Hi @gbortz27, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.