Introducing Surface Duo. A new way to get things done. Join Microsoft experts and other tech professionals for our flagship digital event September 22–24. At over 200mph, every decision counts. Run a simulation with the Renault DP World F1 Team and put your race day. Text Wrapper by MAQ Software retrieves text from any data source and wraps it within the target field, presenting the text in a readable format.
Power BI is a powerful BI tool, but it sadly doesn't support Mac devices.
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.
![Microsoft Bi For Mac Microsoft Bi For Mac](https://screenshots.dgtcdn.net/images/t_app-cover-s,f_auto/p/cb69b4e3-1689-432d-9b6d-7a0f62797189/573801089/power-bi-desktop-screenshot.png)
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.
Sign up for our BI newsletter
Insights from practitioners around the globe.
In your inbox. Every week.
In your inbox. Every week.
No spam, ever. We respect your email privacy. Unsubscribe anytime.
-->This article describes how to generate and install Secure Sockets Layer (SSL) certificates for Power BI visuals.
For the Windows, macOS X, and Linux procedures, you must have the Power BI Visual Tools pbiviz package installed. For more information, see Set up the developer environment.
Create a certificate on Windows
To generate a certificate by using the PowerShell cmdlet
New-SelfSignedCertificate
on Windows 8 and later, run the following command:For Windows 7, the
pbiviz
tool requires the OpenSSL utility to be available from the command line. To install OpenSSL, go to OpenSSL or OpenSSL Binaries.For more information and instructions for installing a certificate, see Create and install a certificate for Windows.
Create a certificate on macOS X
The OpenSSL utility is usually available in the macOS X operating system.
You can also install the OpenSSL utility by running either of the following commands:
- Transtype 4 mac serial number. From the Brew package manager:
- By using MacPorts:
After you install the OpenSSL utility, run the following command to generate a new certificate:
For more information and instructions, see Create and install a certificate for OS X.
Create a certificate on Linux
The OpenSSL utility is usually available in the Linux operating system.
Before you begin, run the following commands to make sure
openssl
and certutil
are installed:If
openssl
and certutil
aren't installed, install the openssl
and libnss3
utilities.Create the SSL configuration file
Create a file called /tmp/openssl.cnf that contains the following text:
Generate root certificate authority
To generate root certificate authority (CA) to sign local certificates, run the following commands:
Generate a certificate for localhost
To generate a certificate for
localhost
using the generated CA and openssl.cnf, run the following commands:Add root certificates
To add a root certificate to the Chrome browser's database, run:
To add a root certificate to the Mozilla Firefox browser's database, run:
To add a system-wide root certificate, run:
Remove root certificates
To remove a root certificate, run:
Generate a certificate manually
You can also generate an SSL certificate manually using OpenSSL. You can specify any tools to generate your certificates.
If the OpenSSL utility is already installed, generate a new certificate by running:
You can usually find the
PowerBI-visuals-tools
web server certificates by running one of the following commands:- For the global instance of the tools:
- For the local instance of the tools:
PEM format
Microsoft Power Bi Pro For Mac
If you use the Privacy Enhanced Mail (PEM) certificate format, save the certificate file as PowerBIVisualTest_public.crt, and save the private key as PowerBIVisualTest_private.key.
![For For](https://software-advice.imgix.net/managed/products/screenshots/screenshot_88770.jpg?w=600&h=450)
PFX format
If you use the Personal Information Exchange (PFX) certificate format, save the certificate file as PowerBIVisualTest_public.pfx.
If your PFX certificate file requires a passphrase:
- In the config file, specify:
- In the
server
section, specify the passphrase by replacing the <YOUR PASSPHRASE> placeholder: