/build/static/layout/Breadcrumb_cap_w.png

Live Feed to PowerBI

Has anyone used PowerBI to create a live stream of data from KACE? I have multiple queries for the data I want to see, and I am now trying to figure out how to display it in PowerBI as well as getting it to update regularly. 

0 Comments   [ + ] Show comments

Answers (2)

Posted by: chucksteel 12 months ago
Red Belt
0

We make extensive use of PowerBI and query the SMA. Here's an old blog post of mine that covers setting up PowerBI Desktop:

https://chucksteel.blogspot.com/2017/09/linking-power-bi-to-quest-k1000-sma.html 

Since I wrote that I have developed some better methods, but that will get you started. One thing that isn't covered in that post is updating a report after it is published to the PowerBI service. That is possible as long as you have a data gateway available that can get to the SMA.


Comments:
  • Thanks for the info, Chuck. I actually came across your blog when I was setting everything up, and it was a great help to me. Updating the report on some sort of interval is what I am mainly trying to accomplish. The report is currently static. - rruhl 12 months ago
    • Have you setup a data gateway?
      https://powerbi.microsoft.com/en-us/gateway/ - chucksteel 11 months ago
      • I have not, but I think this is exactly what I'm looking for—a way to schedule a data refresh. Thank you! - rruhl 11 months ago
Posted by: kiwiblue 10 months ago
Second Degree Green Belt
0

we use a reporting database which is updated every 10 minutes so we dont load up the KACE Database too much. 

Don't be a Stranger!

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

Sign up! or login

Share

 
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