We’ve resolved an issue affecting users of the Power BI integration with Cloud Help Desk, where the column mappings were corrupted in the data export used as the data source when importing data into Power BI. The column mapping has been fixed, so it no longer incorrectly maps column headers with column data.
Run a new export by rerunning or creating a new job on the Exports tab within Cloud Help Desk, and when the report completes you can Refresh the data from Power BI (where you already have the integration between Cloud Help Desk and Power BI setup).
If you’re new to Cloud Help Desk, or new to the Power BI integration, simply follow the initial setup steps to start using Power BI for your advanced Cloud Help Desk reporting needs.
10 Spice ups
When I do a refresh, I see the new comments on older tickets show in Power BI fine. When I do a filter to look at tickets within the last few days, I don’t see any new tickets in PowerBI. I am not sure if the export is getting new tickets in it?
Hey Matt, you can go to the Exports area of Cloud Help Desk and download the XLSX file to take a look - its a standard spreadsheet file that will also open in Excel (not just Power BI). If you take a look there, do you see the new tickets you’re missing? If you need further help (they are missing) shoot us an email to open a support case (support@spiceworks.com).
1 Spice up
Hello,
Getting to error when connect Reports to Power BI
1 Spice up
Hi spicehead-Gfam, contact our support team at support@spiceworks.com to get some help with the Power BI integration!
mushinka
(Mushinka)
6
i am also facing this error, did you manage to resolve?
soporte407
(soporte407)
7
Buen día para Todos,
He logrado resolver el error sobre la conexión al Reporte en Power BI, el tema es que debe haber hecho “login” en el navegador por defecto y en Power BI debe seleccionar en las opciones de seguridad el campo “Usar el explorador web predeterminado”, esto para que al solicitar autorización de conexión lo lleve al navegador predeterminado y acepte la conexión, pruébenlo a mi me funcionó.
3 Spice ups
Am looking to have a weekly report showing the few admins we have with regards to their tickets, status and details. How do I create this report in Power BI or are there any canned reports which might facilitate this?
Hi spicehead-s611z, take a look here to get started with a template for Power BI. You may need to tweak the template to cover your specific needs/goals when it comes to reporting:
https://community.spiceworks.com/support/help-desk-cloud-edition/docs/reporting#advanced-reporting-with-power-bi
I’m receiving the Web.Contents failed to get contents from ’ https://on.spiceworks.com/api/public/power_bi/reports/xlsx ’ (404): Not Found is anyone reporting this issue?
Não consigo de jeito algum sair disso. Do nada começou a apresentar este problema, não abre uma janela para inserir as credenciais, não consigo excluir as atuais ou tentar efetuar novo logon, enfim… fica neste loop. Como resolver???
3 Spice ups
I’m having the same issue as I can’t log in to the connector for some reason. It never brings up the login box.
1 Spice up
I was having the same issue with not being able to log in to the connector (Never brings up the login box), and found a work around on some other site.
“Setting Power BI to use a default web browser has resolved the login issue for users who raised support ticket. We recommend this as the standard configuration going forward.”
In Power BI, go to File > Options and Settings > Options > Security > Scroll down to “Authentication Browser” > Enable “Use my default browser”.
1 Spice up
Same issues here when I try and use this report on a different PC. I did follow all the setup setups like I did on the 1 working PC, but I need to upgrade and can’t turn in my old PC until I get my report working on the new one.
ogozacan
(ogozacan)
17
If you are using Onedrive on your computer. copy it to the location indicated in the example below. If you do not have a Power BI Desktop folder you will need to create one and drop the file into it.
C:\Users\Ozan\OneDrive - ************\Belgeler\Power BI Desktop\Custom Connectors
1 Spice up
Hi @Ben-B-Spiceworks , there are a few separate threads on this issue. One comment down this thread solves the problem, or at least points to the cause. In my case, I have OneDrive which is where the Power BI folders are created. They don’t work there. Once I copied to here %USERNAME%/Documents/Microsoft Power BI Desktop/Custom Connectors/Spiceworks Cloud Help Desk.mez and restarted, works fine. Can’t explain why. Cheers
2 Spice ups
Adding my experience here in case it helps others. Our older users’ Documents folders are redirected to a mapped drive that lives on a DFS server (I know, we need to get them migrated to OneDrive as well). We had to create the Power BI Desktop/Custom Connectors folder there and drop the .mez file in it.
1 Spice up
neroxyr
(neroxyr)
20
I’m having this issue
“Web.Contents failed to get contents from ‘https://on.spiceworks.com/api/public/power_bi/reports/xlsx’ (404): Not Found”
Can’t refresh the data
1 Spice up
