Skip to main content

    Power BI

    New

    Manage Engine Service Desk Plus on Power BI Desktop

    Vote (26) Share
    's profile image

    on 10 Nov 2016 16:41:23

    Please add support for Servicedesk Plus as a Data Source.

    Comments (4)
    's profile image Profile Picture

    aec5a292 00e7-4117-90fb-e70bb1f90efa on 05 Jul 2020 23:54:21

    RE: Manage Engine Service Desk Plus on Power BI Desktop

    I have managed to connect Power BI to Servicedesk plus ondemand using the API, using the code below.


    let
    Source =
    Json.Document(Web.Contents("https://sdpondemand.manageengine.com/api/v3/requests/",
    [
    Headers=[
    #"Accept"="application/vnd.manageengine.sdp.v3+json",
    #"Authorization"="123456789123456789123456789"
    ]
    ]))
    in
    Source


    However, I cannot work out how to increase the number of rows to return to 100. I have read the documentation below but I have no idea how to express this in the Power BI syntax.

    http://ui.servicedeskplus.com/APIDocs3/index.html#view-all-requests

    Does anyone have any idea?

    's profile image Profile Picture

    63ea98c9 1cfa-4403-895a-d7fdc7d19364 on 05 Jul 2020 23:36:36

    RE: Manage Engine Service Desk Plus on Power BI Desktop

    We are really needing this tool to generate reports. It would be very useful mostly on cloud!

    's profile image Profile Picture

    9ec398de 9aa7-473b-af83-2941d25b9482 on 05 Jul 2020 23:32:46

    RE: Manage Engine Service Desk Plus on Power BI Desktop

    Has there been any update with getting a connector to Ondemand Cloud version?

    's profile image Profile Picture

    f4fc6be8 6773-4c9e-abd9-5a126b38c369 on 05 Jul 2020 22:41:07

    RE: Manage Engine Service Desk Plus on Power BI Desktop

    I have the on-prem version and use the data gateway to query my database. I would be interested to getting support for the cloud version so I could migrate to the cloud sooner.