This is the repo for the JNUC 2021 talk regarding building and customizing beautiful dashboards with PowerBI. It includes code examples and extra slides. The JNUC session has been posted to YouTube https://www.youtube.com/watch?v=ZfuVAqUmIEw
Power BI Desktop app is free to use and is Windows only :( If you want to publish or share your dashboard you may need additional licensing. See the links below for more details.
The focus of the JNUC talk was focused around Macs, but many of the same principles can be applied for Mobile Devices like iOS and AppleTV devices.
Jamf has disabled basic authentication for all Jamf Pro instances automatically upon upgrade starting with Jamf Pro 11.5
Jamf Pro 11.5 Important Notices
You will need to enable Basic Authentication in Jamf Pro in order to use the PowerBI Jamf connector, both in the PowerBI app as well as if you use the data refresh feature in PowerBI.
If Basic Auth is not enabled in Jamf, PowerBI will report "The credentials provided for the JamfPro source are invalid".
To re-enable basic authentication in Jamf Pro:
- Go to Settings -> Users accounts and groups
- Click Password Policy (in upper right)
- Check the box 'Allow Basic authentication in addition to Bearer Token authentication'
Please consider voting up this feature idea for Microsoft to support API tokens. https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=1d1acbef-5e21-ef11-8ee8-000d3a7c8d70
These slides includes extra information that didn't make the cut for the JNUC 2021 time limit.
This includes a large section on how to transform the Extension Attributes query. Using those steps make it much easier to use Extension Attributes in visualizations and measures.
Depending on the feeback from JNUC 2021, some of this material may be folded into future presentation.
- Jamf Power BI Integration
- Show off your Reporting Dashboard
- Jamf Training Module 1
- Jamf Training Module 2
Here's a few example visualizations I made with for our Jamf environment.