I came across a great tool to easily create visually appealing reports for our company. Having seen multiple threads on the limitations on KACE reporting I wanted to pass along this information in hopes that it may help someone.
- First, follow Dell's guide on installing an ODBC driver on your computer. I suggest the V5.2.X ODBC driver.
- Second, download Power BI Desktop from Microsoft.
- Open Power BI Desktop and when you're ready to link your K1000's database follow these steps.
1. Get Data
2. Choose MySQL Database
Unless you have changed you Report User's credentials for you K1000, use the default credentials below
Server: 10.10.0.X (You K1000's IP address)
Database: ORG1 (Unless you have other ORGs configured)
- Done! Now you can create visually appealing reports!