We have been using Microsoft OS for decades and Microsoft has provided a group of tools that we are using on daily basis such as Word, PowerPoint, Outlook, Excel, etc.
I have seen many fortune 500 companies that have moved completely to Microsoft services and large transformation projects are happening for multiple other companies. Reports from Tableau and Qlikview have been migrated to Microsoft Power BI because companies are leveraging the complete ecosystem which Microsoft offers and reducing the overall cost.
If we see the market share of Microsoft OS it is clearly visible that Microsoft has captured 76.33% market share and the second is macOS.
Even if windows have high dominance there is some organization that provides mac laptop to their employees because of the better performance that mac offers.
But, Microsoft Power BI is not available for mac users currently and also Microsoft is not planning to launch a separate tool for mac users in the future.
So now the important question is how to use Microsoft Power BI in macOS.
Use Virtual Machine
- Set up Virtual Machine on Cloud platforms like Amazon Web Services (AWS), Azure, and Google Cloud Platform (GCP). For setting up the VM in AWS, you can check the article Launch a Windows Virtual Machine. For setting up the VM in Azure, you can check Quickstart – Create a Windows VM in the Azure portal, and for GCP, you can check Creating and starting a VM instance | Compute Engine Documentation.
Now, the question is there are 3 major cloud providers offering virtual machines which one will be suitable for your requirement? You can check the article Cloud comparison: AWS EC2 vs Azure Virtual Machines vs Google Compute Engine
- Once your VM machine is set up then you can download the latest version of Microsoft Power BI to the virtual machine.
- You can use the Microsoft Remote Desktop application available in Mac App Store to get access to the VM.
- You can upgrade the computing resources very easily without worrying about any hardware changes.
- Pay as you use will determine that you are only being charged for your usage and not for any monthly or yearly charges.
- You get strong backup support and even if there is some problem with your current Mac device but your .pbix files will be saved on the virtual hard disk.
- You get lesser wait time and even there are fewer changes of VM getting hanged which is often seen due to laptop heating issues, memory shortage, etc.
- If your internet connection is off for some reason, then you can not connect to the VM and report development work progress will get hampered.
- VM is slower as vCPUs are half the speed of a physical CPU means 4 core CPU is actually 2 core vCPUs. So you will have to allocate more core while setting up the VM.
- There is an additional delay while using the virtual machine due to the network latency.
- It is not very easy to set up VM and non-technical people will find it difficult to set up VM.
Use Remote PC
I do not see any pros in using a remote pc as it will add additional dependency and cost to using Power BI.
- Additional Cost
- Only Physical upgradation of computing resources is possible.
- Additional Dependency, you will have to make sure that the remote pc is on and does not go to sleep mode.
- Reliable internet connectivity is required.
Parallels is a product that creates a VM inside your Mac. I really like the product because it offers flexibility to its users. You can install multiple OS such as Linux, Windows, or another copy of Mac OS on your Mac device. Also, using a simple installation process you can create the VM in your Mac and use it to run Power BI on your Mac Device. Let`s see the pros and cons of the Parallels to know more about it.
- Open Windows applications side by side with your macOS applications, without having to restart your Mac
- Copy and paste text or drag and drop objects between Mac and Windows.
- Run Windows games and other 3D applications.
- Transfer all your data from a PC and use it on your Mac.*
- Easily share files, devices, and other resources between Windows and Mac.
- Install other operating systems, such as versions of Windows, Linux, another copy of macOS*, and free virtual appliances—and use them together.
- Easy Installation process
- Minimum cost 99$ for home and student use offering 8GB vRAM and 4 core vCPUs.
- Mac can get heated when using parallels and running heavy applications in it.
- Due to windows bloating, Parallels gets slow down.
- Mac battery drains faster.
- Consumes a lot of RAM thus a minimum of 16 GB of RAM should be present in the Mac using parallels.
Turbo.net provides you to package applications and their dependencies in a container which is a lightweight isolated virtual environment. These containers run on top of a turbo virtual machine which is an application virtualization engine. You can add Power BI to your workspace and then start using it through your Mac.
- Turbo containers use a special, lightweight application-level VM called Turbo VM. Turbo VM runs in user mode on top of a single instance of the base operating system.
- Turbo Container startup time is very less in seconds.
- Containerized applications consume only a small percentage of additional CPU and memory consumption relative to native applications. In nearly all cases, Turbo overhead is negligible.
- Expensive Pricing