Hello experts,I have a question regarding the entity "SLA KPI Instance".My main goal is to create a dashboard in Power BI that shows how long the processing of cases takes and whether the time set in the service level agreement can also be adhered to.For this purpose, I have created an "SLA KPI" in the app "Customer Service Hub" under "Service Management", as well as a Service Level Agreement (SLA) and then an entity.Unfortunately, however, I cannot find the two columns that connect the entity "slakpiinstance" and "incident" in order to enable a display in PowerBI.I would also be very grateful for any other tips on how best to display the duration of cases!Please help me to find out how I can establish a connection here.Thank you in advance and best regards,Daniel
Hi Leah Ju,
Thank you very much for this article!
I will try it by means of this explanation and think that it will help me.
Kind regards,
Daniel
Hi JMaye2,
Thank you very much for your comments.
However, I have already put this together so far - my problem is that I don't know how to access this timer using PowerBI.
Hello danielst
I worked on the SLAs by case priority for a few days and went through a few youtube videos- . www.youtube.com/watch
I currently have a First Response KPI and a Resolve By KPI.
Located in the Service Level Agreements I have Service Priority
Located in the Service Priority I defined the SLA Items for High Priority, Normal Priority and Low Priority with the applicable SLA KPIs from first pic above.
This affords the ability for First Response in timer- (this example is for high priority) with failure after 1 hour.
I hope this helps.
Hi danielst,
Maybe you can refer the following link:
How to Translate Dynamics 365 Field Values to Power BI | Magnetism Solutions | NZ (Auckland, Wellington, Christchurch and Dunedin)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 101 Super User 2025 Season 2
Suresh Kulla 70 Super User 2025 Season 2
Daniyal Khaleel 56