1

Hello SpiceHeads,

Some of you may remember our Cloud Help Desk reporting integration “early release” - whether you are already familiar or this is news to you, we think you’ll be happy with our progress! After listening to your feedback on the Power BI integration prototype, the Cloud Help Desk team worked hard to streamline the process that allows you to feed your Cloud Help Desk ticket data into Power BI.

We know many of you already use Power BI and the hundreds of data connectors provided by Microsoft and their partners to grab and report on your data from various sources. We’d love for you to try out our Power BI Desktop Data Connector, which you can load into your own installation of Microsoft’s Power BI Desktop (free, just like Cloud Help Desk).

In short, using Power BI to report on your Cloud Help Desk data is now easier than ever, allowing you to generate the customized ticket reports you need, when you need them.

Want to get started? Our connector allows you to easily pull data directly from your Cloud Help Desk account, and refresh that data into our Power BI report template, with literally one click. You just need to complete the initial setup steps which we’ve outlined in our documentation here: https://community.spiceworks.com/support/help-desk-cloud-edition/docs/reporting#advanced-reporting-with-power-bi

You can read more about Power BI data connectors here .

19 Spice ups
2

Great, I can see some people in the community that are going to be happy!

2 Spice ups
3

Will this work if you are using your own custom PowerBI layout and not the Spiceworks template?

4

Yes, the template is intended to jumpstart folks that aren’t familiar with Power BI or want to start with a sample. But the connector should allow you to craft your own Power BI reports from scratch.

2 Spice ups
5

Not working for me. Stuck on Step 5 and 8 in the documentation. Doesn’t look like Power BI is able to connect back to my cloud helpdesk and I’ve double verified the cloud helpdesk data connector is installed correctly.Any ideas?

6

Hi drake6, if you’re having trouble connecting shoot us an email and we can help you get it sorted out: support@spiceworks.com.

1 Spice up
7

Hello,

I have integrated Power Bi with Cloud Help Desk successfully.

What I need to do is to export the total amount of hours spent on each Organization monthly, but I am not sure how to do it.

Can anyone help me? Or is there any tutorial?

Thanks.

8

I have been trying to connect powerBI to my cloudhelpdesk but am in stuck in step 5. I think the cloud helpdesk data connector is installed correctlyBut a login prompt should appear which is not happening for me.Could you please help me with this asap.

I has send a mail to support@spiceworks.com.But no reply yet.

I have a presentation tommorrow,could you please reply ASAP.

Thanks

9

Hi, I looked in our system and I do see that Support replied to you yesterday around 11:38 AM CT. You may want to look in your spam folder for an email from support@spiceworks.com referencing SS1-54116. If you cannot find that, please send me a direct message.

10

Thank you for the reply.

Sorry i didnt check in my spam folder.

i will go through the email and will let u know.

1 Spice up
11

Will Power Bi work with the HDS version?

12

Hi John, currently it works only with Cloud Help Desk. We don’t have any plans to add this to HDS right now.

13

The connector Login screen does not show up at all

Reached out to support and no luck

0fd704e2-7717-49d1-8f7a-5a4db6cdc4c7-Screenshot_2022-01-25_154622.png
0fd704e2-7717-49d1-8f7a-5a4db6cdc4c7-Screenshot_2022-01-25_154622.png800×585 65 KB
14

Thanks for the Power BI. I just want a print out of a individual ticket.

How do I do that?

I have Power BI installed and linking to updates and also Spiceworks connector working, and can see the actual data brought in from our Spiceworks Cloud. There are loads of fields and keys and things. How do I use this to just report on 1 Job using the comments, Techs, headers, keys, attributes, custom attributes, Jobs and things?

Can you help me with details at this point to create a print out of 1 ticket?

Thanks heaps.

Peter

1 Spice up
15

Hi fkepw (Peter), try posting up a question for more help with customizing Power BI: https://community.spiceworks.com/spiceworks-support/general or https://community.spiceworks.com/spiceworks-support/spiceworks-cloud-help-desk-support

16

This was the ticket to missing sign-in/authentication window for me: https://community.spiceworks.com/blogs/help-desk-cloud-edition-release-notes/3596-cloud-help-desk-power-bi-integration-fix

17

Can someone direct me to an explanation on how to make my custom attributes to be headers with the value item for each ticket in power BI

I’ll ask about proper labor sums another time.

1 Spice up
18

This is a start.

Although rather than using a connector, why does Spiceworks simply build some secure oData feeds that we can tap into based on the login. This way the Power BI can be published to the Power BI cloud and be updated.

2 Spice ups
19

Followed all steps in the guide and it was all working fine on the first and second refreshes, i then got the following error, which I haven’t managed to get past:

‘The downloaded data is HTML, which isn’t the expected type. The URL may be wrong or you might not have provided the right credentials to the server.’

Any ideas?

1 Spice up
20

adrian142, we released a fix recently for similar behavior, so if you’re still seeing this type of error today please let us know by contacting support@spiceworks.com to provide us with more details so we can investigate.

Be sure you have a recent XLSX export that is available for download from CHD on the Exports page. If you can run a new XLSX there and download/open the file, then Power BI should be able to update.