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.
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
Lotus365 login opens the door to an exciting betting platform filled with endless opportunities. With Lotus 365 login, you can explore thrilling promotions and a user-friendly experience like no other. The Lotus365 is quick and hassle-free, ensuring you never miss a moment of the action. Step in today and enjoy the ultimate betting experience!
Visit on- https://officiallotus365.com/login