Power Defense (Oberdiah) Mac OS
Power BI is a powerful BI tool, but it sadly doesn't support Mac devices.
Installation of latest preview release via Homebrew on macOS 10.13 or higher. After you've installed Homebrew, you can install PowerShell. First, install the Cask-Versions package that lets you install alternative versions of cask packages. Cybersecurity platform war as Apple Mac threats outpace Microsoft Windows ones for first time. LightRocket via Getty Images. My first experience of technology platform wars was back in 1985 when.
Power Defense (oberdiah) Mac Os X
A couple of years ago, I was working for a company where 90% of our staff had a MacBook and loved it, but there was no way for our Data Team to work with Power BI to build out reporting. Then we turned into another tool named Holistics, a cloud-based one.
In this post, I will share my experiences implementing Power BI on Mac OS, which I hope is helpful to you if you are looking for a solution.
Disclaimer: I fell in love with Holistics at the previous company, and am now working for Holistics!
Since Power BI can't run on a Mac, here are our recommendations to run Power BI on Macintosh Devices.
- Install and run Power BI on a Virtual Machine, then remote in to that Virtual Machine.
- Install and run Power BI on a PC, then use a remote viewer to control that PC.
- Use an alternative BI solution.
- Install Windows on Mac using Boot Camp
To give you a little context about Microsoft's plan on supporting Power BI on Mac devices, they are not considering developing Power BI desktop for Mac devices anytime soon.
You can also visit this link to keep track of their upcoming plans.
You can set-up a Windows Virtual Machine on Azure, Google Cloud or AWS.
- Azure: https://azure.microsoft.com/en-us/services/virtual-machines/ (starting from $61/month)
- AWS: https://aws.amazon.com/getting-started/tutorials/launch-windows-vm/
Then you install and run Power BI on that Virtual Machine.
Finally, install Microsoft Remote Desktop for Mac on each device to give your team access to that VM.
There are a couple of disadvantages to this approach, however:
- It's difficult to control permission access and version history.
- You can only have one person working on a machine at a time, since Power BI for desktop is not a collaborative tool.
It's a little bit the same with the first method, however, this time, you use a physical machine.
You set-up a Windows PC, install and run Power BI on that PC.
Install TeamViewer, AnyDesk, or MS Remote Desktop to give people access to that PC and use Power BI from their Macs.
Cons: same with the first method, and you have to maintain a physical PC.
Power BI is powerful — it helps your team consolidate data and build dashboards and reports with a powerful data modeling layer. It's not easy to find a great tool in the market to replace Power BI, but here are two alternative solutions I recommend which is 100% cloud-based, can replicate its functionalities, and in some cases do even more.
1. Holistics
Holistics is a powerful full-stack data platform that allows companies to set up an end-to-end, reusable, and scalable data analytics stack with minimal engineering resources.
It not only gives data analysts a powerful SQL-based data modeling approach, but it also helps them build a data warehouse and automate reporting. Holistics is also designed to empowers non-technical users to get insights with a strong self-service analytics offering.
Holistics vs Power BI: https://www.holistics.io/compare/holistics-vs-powerbi/
2. Looker + StitchData
Looker is a business intelligence and big data analytics platform that helps you explore, analyze and share real-time business analytics easily.
Looker is also a powerful server-based Data Modeling BI tool, however, they don't support Data Transforms and Data Imports, so you will need another tool for that called StitchData. Together, you get all the power of Power BI with none of the Windows lock-in.
Boot Camp is a utility that helps you install Microsoft Windows 10 on your Mac, then switch between macOS and Windows when restarting your Mac.
You can learn more about how to use it here
I like Power BI's product, but it is difficult to keep using Power BI given that the tool is built exclusively for the Windows Desktop. Instead of allowing your data team to work collaboratively, your data pipeline will depend on Windows. This is difficult and restrictive if your organization works primarily on Mac.
The upshot here is that if you do not use a Microsoft-stack at your organization, a 100% cloud-based solution would be a better fit for your needs.
Power Defense (oberdiah) Mac Os Pro
Name (Version) | Target | Authority | Last Modified | Resources |
---|---|---|---|---|
Cisco ISE STIG (Version 1, Release 1) | Cisco Identity Services Engine | Defense Information Systems Agency | 04/30/2021 | Standalone XCCDF 1.1.4 - Cisco ISE STIG |
Canonical Ubuntu 16.04 STIG (Ver 2, Rel 3) | Canonical Ubuntu 16.04 LTS (Long Term Support) | Defense Information Systems Agency | 04/30/2021 | SCAP 1.2 Content - Sunset - Canonical Ubuntu 16.04 LTS STIG Benchmark - Ver 2, Rel 3 Automated Content - SCC 5.4 Ubuntu 16 AMD64 Automated Content - SCC 5.4 Ubuntu 16 i686 Automated Content - SCC 5.4 Ubuntu 18 AMD64 Standalone XCCDF 1.1.4 - Sunset - Canonical Ubuntu 16.04 LTS STIG - Ver 2, Rel 3 |
Solaris 11 (SPARC and x86) Manual STIG (Version 2, Release 3) | Sun Solaris | Defense Information Systems Agency | 04/30/2021 | SCAP 1.2 Content - Solaris 11 SPARC STIG Benchmark - Ver 2, Rel 2 SCAP 1.2 Content - Solaris 11 X86 STIG Benchmark - Ver 2, Rel 2 Automated Content - SCC 5.4 Solaris 10 i386 Automated Content - SCC 5.4 Solaris 10 SPARC Automated Content - SCC 5.4 Solaris 11 i386 Automated Content - SCC 5.4 Solaris 11 SPARC Standalone XCCDF 1.1.4 - Solaris 11 SPARC STIG - Ver 2, Rel 3 Standalone XCCDF 1.1.4 - Solaris 11 x86 STIG - Ver 2, Rel 3 |
Red Hat 6 STIG (Version 2, Release 2) | Red Hat Enterprise Linux 6 | Defense Information Systems Agency | 04/30/2021 | SCAP 1.2 Content - Sunset - Red Hat Enterprise Linux 6 STIG Benchmark - Ver 2, Rel 2 Automated Content - SCC 5.4 RHEL 6 i686 Automated Content - SCC 5.4 RHEL 6 x86 64 Automated Content - SCC 5.4 RHEL 7/Oracle Linux 7/SLES12 x86 64 Automated Content - SCC 5.4 RHEL 8 x86 64 Standalone XCCDF 1.1.4 - Sunset - Red Hat Enterprise Linux 6 STIG - Ver 2, Rel 2 |
SUSE Linux Enterprise Server (SLES) 12 STIG (Ver 2, Rel 3) | SUSE Linux Enterprise Server 12.0 | Defense Information Systems Agency | 04/30/2021 | SCAP 1.2 Content - Suse Linux Enterrprirse Server 12 STIG Benchmark - Ver 2, Rel 3 Automated Content - SCC 5.4 RHEL 6 i686 Automated Content - SCC 5.4 RHEL 6 x86 64 Automated Content - SCC 5.4 RHEL 7/Oracle Linux 7/SLES12 x86 64 Automated Content - SCC 5.4 RHEL 8 x86 64 Standalone XCCDF 1.1.4 - Suse Linux Enterprise Server (SLES) 12 STIG - Ver 2, Rel 3 |
Canonical Ubuntu 18.04 LTS for Ansible (Version 2, Release 2) | Canonical Ubuntu 18.04 LTS for Ansible | Defense Information Systems Agency | 04/30/2021 | Automated Content - SCC 5.4 Ubuntu 16 AMD64 Automated Content - SCC 5.4 Ubuntu 16 i686 Automated Content - SCC 5.4 Ubuntu 18 AMD64 Standalone XCCDF 1.1.4 - Canonical Ubuntu 18.04 LTS for Ansible STIG - Ver 2, Rel 2 |
IBM AIX 7.X STIG (Ver 2, Rel 2) | IBM AIX 7.1 IBM AIX 7.2 | Defense Information Systems Agency | 04/30/2021 | Standalone XCCDF 1.1.4 - IBM AIX 7.X STIG - Ver 2, Rel 2 |
zOS ACF2 STIG (Version 6, Release 49) | IBM OS390 | Defense Information Systems Agency | 04/30/2021 | Standalone XCCDF 1.1.4 - IBM z/OS STIG Standalone XCCDF 1.1.4 - z/OS ACF2 Products - Ver 6, Rel 49 |
zOS TSS STIG (Version 6, Release 49) | IBM OS390 | Defense Information Systems Agency | 04/30/2021 | Standalone XCCDF 1.1.4 - IBM z/OS STIG Standalone XCCDF 1.1.4 - z/OS TSS Products - Ver 6, Rel 49 |
zOS RACF STIG (Version 6, Release 49) | IBM OS390 | Defense Information Systems Agency | 04/30/2021 | Standalone XCCDF 1.1.4 - IBM z/OS STIG Standalone XCCDF 1.1.4 - z/OS RACF Products - Ver 6, Rel 49 |
Suse Linux Enterprise Server (SLES) 15 STIG (Version 1, Release 2) | SUSE Enterprise Linux 15 | Defense Information Systems Agency | 04/30/2021 | Standalone XCCDF 1.1.4 - Suse Linux Enterprise Server (SLES) 15 STIG - Ver 1, Rel 2 |
Oracle Linux 7 STIG (Ver 2, Rel 3) | Oracle Linux 7 | Defense Information Systems Agency | 04/29/2021 | SCAP 1.2 Content - Oracle Linux 7 STIG Benchmark - Ver 2, Rel 3 Automated Content - SCC 5.4 RHEL 6 i686 Automated Content - SCC 5.4 RHEL 6 x86 64 Automated Content - SCC 5.4 RHEL 7/Oracle Linux 7/SLES12 x86 64 Automated Content - SCC 5.4 RHEL 8 x86 64 Standalone XCCDF 1.1.4 - Oracle Linux 7 STIG - Ver 2, Rel 3 |
Apple OS X 10.14 (Mojave) STIG (Ver 2, Rel 3) | Apple OS X 10.14 | Defense Information Systems Agency | 04/29/2021 | Standalone XCCDF 1.1.4 - Apple OS X 10.14 STIG - Ver 2, Rel 3 |
Solaris 10 (SPARC and x86) Manual STIG (Version 2, Release 2) | Oracle Solaris 10.0 | Defense Information Systems Agency | 04/29/2021 | SCAP 1.2 Content - Solaris 10 SPARC STIG Benchmark - Ver 2, Rel 2 SCAP 1.2 Content - Solaris 10 x86 STIG Benchmark - Ver 2, Rel 2 Automated Content - SCC 5.4 Solaris 10 i386 Automated Content - SCC 5.4 Solaris 10 SPARC Automated Content - SCC 5.4 Solaris 11 i386 Automated Content - SCC 5.4 Solaris 11 SPARC Standalone XCCDF 1.1.4 - Solaris 10 SPARC STIG - Ver 2, Rel 2 Standalone XCCDF 1.1.4 - Solaris 10 X86 STIG - Ver 2, Rel 2 |
Adobe Acrobat Reader DC Classic Track (Version 2, Release 1) | Adobe Acrobat Reader | Defense Information Systems Agency | 04/29/2021 | SCAP 1.2 Content - Adobe Acrobat Reader DC Classic Track STIG Benchmark - Ver 2, Rel 1 Standalone XCCDF 1.1.4 - Sunset - Adobe Acrobat Reader DC Classic Track STIG - Ver 2, Rel 1 |
Apple OS X 10.15 STIG (Ver 1, Rel 4) | Apple OS X 10.15 | Defense Information Systems Agency | 04/29/2021 | Automated Content - SCC 5.4 Mac OS X x86 64 Standalone XCCDF 1.1.4 - Apple OS X 10.15 STIG - Ver 1, Rel 4 |
Oracle Linux 6 STIG (Version 2, Release 3) | Oracle Linux 6 | Defense Information Systems Agency | 04/29/2021 | Standalone XCCDF 1.1.4 - Oracle Linux 6 STIG - Ver 2, Rel 3 |
Apple OS X 10.13 STIG (Ver 2, Rel 3) | Apple macOS 10.13 | Defense Information Systems Agency | 04/29/2021 | Standalone XCCDF 1.1.4 - Apple OS X 10.13 STIG - Ver 2, Rel 3 |
Apple macOS 11 STIG (Ver 1, Rel 2) | Apple macOS 11.0 (Big Sur) | Defense Information Systems Agency | 04/29/2021 | Automated Content - SCC 5.4 Mac OS X x86 64 Standalone XCCDF 1.1.4 - Apple macOS 11 (Big Sur) STIG - Ver 1, Rel 2 |
Crunchy Data PostgreSQL STIG (Ver 1, Rel 1) | CrunchyData PostgreSQL | Defense Information Systems Agency | 04/28/2021 | Standalone XCCDF 1.1.4 - Crunchy Data PostgreSQL STIG - Ver 1, Rel 1 |