Miscellaneous Question

Power BI and KACE

10/11/2018 1052 views
I found this article https://www.itninja.com/blog/view/power-bi-desktop-setup-for-visual-kace-reports

I followed the steps and got Power BI to connect tot he KACE database but when I browse the data is the ORG1:MACHINE table but it only lists 31 records. There should be WAY more than that. Any ideas what might be going on?
1 Comment   [ + ] Show comment


  • Does your appliance have Orgs enabled? If so, are your the bulk of your machines in ORG1 or another ORG?
    • Its a possibility, I do have to select the right one when using the web interface. I just didnt see any other ORG#'s when I was browsing the database with MySQL Workbench. Is it possible to have only specific ORGs set up with database access? That could explain what I only see ORG1.
      • Yes, each ORG will have its own reporting user. ORG1 is R1, ORG2 is R2, etc. I don't have orgs on my appliance but I would assume the access needs to be configured for each one.

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ