What are the additional fields that you would like to have as part of the Microsoft Power BI connector build-in connector ?
Please share us your thoughts and wishes.
"...in the next version?" - Can you point me to documentation for the first version? I'm really trying to get our reports combined
Hi @JustA_SWSD_AdminThe Power BI connector is currently in Beta version .
We are working on publicly as a Microsoft build in connector . After the connector will be released, it is part of our roadmap to add additional fields. I would like to hear your side which exact fields from the API would you like there to be.
Regarding to the Documentation, the first Beta version documentation is here: https://documentation.solarwinds.com/archive/pdf/swsd/swsd_power_bi_beta.pdfIn case you wanna use the Power BI Beta connector you can a contact SE or me.
I personally would like to see the Changes exposed to this connector. I don't personally see howe the audit or service catalog will be helpful to anyone in a PowerBI Dashboard...
Along with assets (computers) I would like to see details from users fields. like departments and sites.
Manual time entry for incidents
Priority
Assigned to
Assets would be important for example for us.
But this is because ServiceDesk has csv export and not real table view export which Power BI can help us with.
Subcategories, i know is there, but it keeps disappearing when I refresh the connector
Might be that the subcategory is empty for the specific incident
We would greatly appreciate if you could prioritize adding the following which are essential for IT performance report:
@carldeancatabay Thank you for your response.We have the data for SLA in our last cloud connector in the Power BI marketplace.For the full list of fields: https://documentation.solarwinds.com/en/success_center/swsd/content/completeguidetoswsd/powerbi.htm#link6 Regarding changes, it is in our roadmap. About CSAT please clarify which fields and what is the use case?Thank you
I would like to have the Closed Time Stamp field added to the Incident API.
The API for Incidents is only part of the solution. You also need to have Tasks assigned to those Incidents to tell the true store of where time is being spent on a ticket.
I also support and API for Assets and include software installed on those Assets.
"Total Time Spent" on tickets is a critical metric for us as we use it to determine staffing due to actual time spent on tickets and also to determine what issues consume most of our time.
@mike.kesslerThank you for you ask. Please describe which field/s exactly you mean. thanks
@Nucleartoaster thank you for asking those fields already exist in the connector. You can see the full list here: https://documentation.solarwinds.com/en/success_center/swsd/content/completeguidetoswsd/powerbi.htm#link6
@samulski Thank you for your ask. We will add that to the next version.
@dpitcockThank you for your ask. Please describe which fields exactly you mean.
I see that you wrote to add it to the Incident API - so do you mean the API or to the Power BI connector? thx
To the full list of fields that exist today in the connector: https://documentation.solarwinds.com/en/success_center/swsd/content/completeguidetoswsd/powerbi.htm#link6
This field.
Ok thanks. Are you also planning in adding some kind of table view with exporting views etc? As this would also resolve our problem. CSV would mean we have to take some extra steps. SharePoint does have the option and opens the file with filters on each column.
@samulski We will add the asset data in the next version of the Power BI connector. You will have all information on assets directly to the Power BI and no need to do export from the platform and import it to the Power BI. Please let me know if it is still not clear.
Ability to track task completions in addition to incident resolution. (Ideally in order to track task that are completed by various departments so that production by user can be tracked.)
I'd like to see a change with how the date and time is formatted. Right now it is in some sort of time zone format that I can't get Power BI to recognize
I think I am going to have to see examples. I use Power BI not, and I get all of the computers, users license information etc., in my MS Dashboard. I also imported one for Intune, which tells me compliance to our policies. What is the power BI connector going to provide me I am not getting today. I would like to see a automated report of say the Service desk dashboard, where its maybe zeroing in on KPI items you can define. Example, like on the dashboard, SLA breeches. But the KPI could be 3 allowed breeches a month. The report would show we are still in spec. Or a ticket closure KPI where all tickets are closed with in 4 hours of submission based on status. Report on that KPI. I think Power BI is a great tool for reporting KPI's out and automating them, but as for some of the asset information, I get that now from Microsoft. Network items might be nice, but since I do not have observability or an on-premise Orion solution, I have to hope the SNMP alignment will work for the network items.
Additional fields that would enhance the Microsoft power Bi services connector include geospatial data fields, temporal fields, hierarchical fields, derived calculated fields, semantic fields, custom metadata fields, external API integration, and machine learning fields. These additions would facilitate advanced analysis and visualization within Power BI, improving decision-making capabilities.
You now provide asset information as part of the API but the Owner field is not one of the fields that is offered. That is one of the most important fields since that is where you define which user is assigned that asset. For example, who was the laptop assigned to.
I would like to have the Task data added to the incident API. This ties directly to the incident record and shows all the work (tasks) that was associated to the incident.
We would like to have the possibility to use contracts and its details in Power BI.
Also it would be great if groups and its users could be accessed via Power BI.
