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

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

      • suryaprakash's avatar
        suryaprakash
        New Member
        9 years ago

        Hi Sandra,

        You can connect to ServiceNow database using Servicenow ODBC drivers. The ServiceNow ODBC driver allows an ODBC client to connect to the ServiceNow platform and get data from servicenow. We need to have atleast read only access to the Servicenow DB.

        Also by using ETL(SSIS) we can get data from servicenow to SQL server DB through servicenow ODBC drivers. Tables like Incident, sc_req_items, Sc_task, Sc_Request, Change_Request, CMDB_CI etc., And then you can create personalised views or tabular model on top of it.

        For more info on ServiceNow driver details/Installation - Click here

        Regards,

        Surya Temkar