Tips for Improving Workflow and Development time in Power BI
- Jerome Dixon
- Aug 23, 2021
- 1 min read
Updated: Aug 25, 2021

Here’s a quick tip I found – use a persistent spot windows server instance on AWS with OneDrive. This sped up my development time and workflow considerably!

If you are new to AWS I recommend this Medium blog post by Tim Fogarty for a start. Getting started with AWS. https://medium.com/tfogo/getting-started-with-aws-d7c51133fc92.
Here is the base architecture we will be installing our applications from:

The key things we need for this configuration and setup are:
1. Persistent Spot EC2 Instance (to reduce costs)

2. AMI type: Windows_Server-2019-English-Full-Base-2021.06.09

3. Static Elastic IP: https://aws.amazon.com/premiumsupport/knowledge-center/ec2-associate-static-public-ip/
4. Security Group: Open ports 22 and 3389

5. Remote Desktop Connection: https://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/connecting_to_windows_instance.html
Once connected to your instance, you can now install and configure your applications: OneDrive, PowerBI Desktop, R/RStudio, Node, and PowerShell (for custom R visuals)
After installation, I saved my remote desktop connection file (.rdp) to OneDrive so I could access this instance on any device I was working on.
In the comments section - Please let me know how this works for you or any other tips you found to reduce your development time.

Jerome is a Senior Operations Research Analyst here at CANA. You can contact Jerome at jdixon@canallc.com.
Great platform! I’ve been using Lotus365 for a few weeks now, and I’m really impressed with the range of games and sports betting options. The lotus365login process is super smooth and secure, which makes it easy to jump right into the action. Looking forward to seeing what new features they roll out next!
visit on:https://lotus365s.com.in/
Ganesha Book is your trusted destination for seamless online sports engagement and real-time match updates. Experience a user-friendly platform designed for excitement, security, and convenience.
Visit more- https://ganeshabook.in/
Reddy Anna Book gives the best match insights every day. With Reddy Anna, my cricket predictions have improved a lot. The platform is super easy to use and updates are quick. If you're serious about cricket, Reddy Anna Book is a must!
Visit more- https://thereddyannabook.in/
Great article! I really enjoyed reading about the latest trends in online gaming and betting. It's always exciting to see the growth of the industry. For anyone interested in exploring more options for casino games and betting, I highly recommend checking out FairPlay247. They offer a wide range of gaming options and a secure platform for an exciting betting experience for more information visit https://fairplay247.ind.in/
Nhà cái uy tín là danh sách các nhà cái cá cược trực tuyến có độ uy tín cao trên thị trường Việt Nam. nhacaiuytin top được tổng hợp dựa trên trải nghiệm thực tế của tối thiểu 1000 người chơi. nhacaiuytin.top