• State Not Answered
  • Replies 2 replies
  • Subscribers 27 subscribers
  • Views 596 views
  • Users 0 members are here
Options
Related

Power BI / SQL Reporting WHD

ld23mc

Looking to get a Power BI Dashboard with data from our Helpdesk database, what I am finding is the priority type / alert levels is having an impact on the data being shown. One of the metrics we report on is tickets that need attention. I am hoping to get a SQL query setup to allow this but I feel I am over complicating it with the amount of conditional logic that would be going on. Does anyone have anything similar they can share?

  • 0

    We make extensive use of Request Type (Problem Type in SQL) and Status to sort our tickets. Most of our reporting is SSRS/PowerBI based but I believe our techs use the Dashboard widgets (based on shared queries) for their monitoring.

    One recurring thing I have noticed is the presence of NULL in a lot of fields where one may expect a 0 or 1. We don't report on Priority Type or Alert Levels so I'm not familiar with those fields. 

  • 0 in reply to Peter_2022

    Have you ever tried using the API to pull data for reporting? We use the hosted version so I don't think I can get direct SQL access and wondered if (the notoriously deficient) API worked for reporting?

    I'd also add the built-in dashboard is ok, but who decided that you can't sort a chart by date!?!  It makes a number of reports less than useful.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.