Forum Discussion

jridener's avatar
jridener
New Member
9 years ago
Solved

ServiceNow connector reads only open incidents

Using the ServiceNow connector here: https://powerbi.microsoft.com/en-us/blog/explore-your-servicenow-data-with-power-bi/ I'm able to create a dashboard with ServiceNow open incidents only. Recently ...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi jridener,

    From official article, I haven’t found anything else expect the following requirements when connecting to ServiceNow. However, you are able to view part data of incidents, I would recommend you check if some permissions of your account is restricted in  ServiceNow.

    - An account that can access yourorganization.service-now.com with Basic authentication (Single Sign-On is not supported in this version)

    - The account must have rest_service role and read access to incident table


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi jridener,

Do you perform the steps in this article to connect to ServicesNow from Power BI? I would recommend you check the following things.

1. Make sure that you  have rest_service role and read access to incident table. And work with your ServiceNow admin to check if you need to have any additional permissions for your custom instance.
2. Specify different number of incidents and different number of days during connection and check the dashboard.
3. Based on Theresa’s comment in this blog, the issue could also occur when the instance is “fallen asleep”, in your scenario, please make sure the instance is online before connecting to it.


Thanks,
Lydia Zhang

jridener's avatar
jridener
New Member
9 years ago

Hi Anonymous,

 

Thanks for the quick feedback!

 

I have confirmed the rest_service role and access to the incident table with the ServiceNow admin as well as made changes to the number of incidents and days for the connection.

 

I will follow up with our SN admin on waking up the SN instance before testing as we're also on a dev SN instance at the moment.

 

Thanks,

 

John

  • jridener's avatar
    jridener
    New Member
    9 years ago

    Hi Anonymous,

     

    I wanted to follow up with the current results of this question.

     

    I was able to connect Power BI to include recently resolved and closed incidents by adding the admin role to the account I'm using to read in data from ServiceNow. 

     

    Our ServiceNow admin would prefer to not have a second admin account just for PowerBi. Are you aware of specific permissions that besides the rest_service role and access to the incident table that might be available in an admin account that Power BI requires?

     

    Thanks,

     

    John

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi jridener,

      From official article, I haven’t found anything else expect the following requirements when connecting to ServiceNow. However, you are able to view part data of incidents, I would recommend you check if some permissions of your account is restricted in  ServiceNow.

      - An account that can access yourorganization.service-now.com with Basic authentication (Single Sign-On is not supported in this version)

      - The account must have rest_service role and read access to incident table


      Thanks,
      Lydia Zhang

      • sanuflo's avatar
        sanuflo
        Frequent Visitor
        9 years ago

        Good Day!! I saw your answer about the ServiceNow integration, and you said that you transfer the data from ServiceNow into your SQL Server database. I’m trying to create my own dashboards with the information from ServiceNow but im using the Excel files that I download from the app, Can you please explain me how can i connect my ServiceNow with my SQL Server database in order to get the info from my SQL DB instead of Excel files? Based on your experience which one it’s the best way of obtain the info from Service now? my boss doesn’t like the  Power BI content pack for ServiceNow incidents dashboard and he want to create a personalized view.

         

        Thanks a lot for your help

         

        Sandra