1

Hi There,

I’m back from Spiceworld and super energized to start using PowerBI to potentially report on cloud helpdesk metrics.

Are the beta/demo reports that @francois-sw ​ used in his cloud helpdesk presentation available?

Thanks!

Eric

6 Spice ups
2

@benb ​ I believe Ben Brookshire co-led the session that featured the reports so tagging him in here. Would be great to have some building blocks to play with! :slight_smile:

Thanks,

Eric

3

Is someone able to add what information was shared at Spiceworld for those who weren’t at the conference? It sounds like there is/will be a way to use PowerBI to connect to the cloud helpdesk? I’m sure others will find this information helpful as well since this thread comes up when you search for using Spiceworks cloud with PowerBI.
Thanks,
Chris

2 Spice ups
4

Anyone had any luck locating those reports? I know, I’m a total dork for wanting this lol.

5

You aren’t a dork…I recently migrated to Cloud HelpDesk and truly didn’t realize there really is no reporting and I reply on this for my report to management week to week, so I may be migrating back to On-Prem, sad to say.

6

hey all, i too would be interested in linked PowerBI to Spiceworks in the cloud as the reporting sucks in cloud!!

7

I finally made use of the template they provided…here what I did…

  1. Export ALL tickets to Excel Format.

  2. I downloaded the PowerBi Template that @francois-sw ​ provided.

  3. I run PowerBi and import the provided template.

  4. I import the ALL Tickets Spreadsheet into that PowerBi template.

  5. My Ultimate Goal is to report on Summary, Latest Updates and Category…but to get the report where I need it, I filter to the following.

    1. summary, all_comments, category_name, status, status_changed_at

  6. Then I export that as a CSV and open in Excel.

  7. I then sort by date and status alphabetical so I can pull out what I closed over the past week.

  8. Then I short Z-A on status so I can copy just what is open.

  9. Then I slightly modify for OneNote, Paste into Outlook and report to management what is closed, what I am working on and all open tickets.

Seems like a lot of work but once you get the template set, as long as you export a fresh copy of the tickets for the week, you should just be able to open PowerBi, import saved template, start at step 6 and export the CSV. I still want all of the reporting (and then some) that the On-Prem had but this will meet my needs for now.

1 Spice up
8

For those who may not already know, Power BI integration info is available here: Cloud Help Desk is getting custom reporting