Forum Discussion

smerchant's avatar
smerchant
Helper I
9 years ago

ServiceNow Integration Content Pack - Live Data

I have connected the ServiceNow content pack and reports/dashboard are generated fine, but I noticed that history textbox where you put number of days has no impact on the report.  I have refreshed the data but it is still showning me data for 1 June 2017?

 

Is there any way to get the live data from ServiceNow through this content pack? e.g. if I put 30 days I should take data for 30 days including today?  Am I missing something here?

 

Thanks,

S

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    smerchant,

    I am afraid that you are not able to get the live data through ServiceNow content pack. This content pack includes your recently resolved and recently closed incidents, the data contains in it may not be up-to-date comparing to the data in ServiceNow.

    In your scenario, you can transfer the data from ServiceNow to SQL Server database and establish a direct link between ServiceNow and SQL Server to get latest data, then connect to the SQL Server database from Power BI Desktop. In Power BI Desktop, you can create your own reports.

    In addition, you can vote the idea that add a ServiceNow connector in Power BI Desktop.


    Regards,
    Lydia

    • smerchant's avatar
      smerchant
      Helper I
      9 years ago
      Anonymous, thanks for your reply. Is there any documentation available explaining what do we really get for example, 30 or 60 days data and when it refresh as per the schedule what does it bring?
  • antonstorozhuk's avatar
    antonstorozhuk
    Helper V
    3 years ago

    Hello smerchant ,

    I’d like to propose and alternative solution for you, you may connect your Servicenow instance to Power BI with the help of our add-on - Power BI Connector for ServiceNow:

    We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at [email protected] if you need any assistance.

     

    Thank you.

    Regards,

    Anton

    ===
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.