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 t...
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?
    • smerchant's avatar
      smerchant
      Helper I
      9 years ago

      Anonymous

       

      Thanks. Do we know how many days of data is being returned from the content pack? 30 day or 60 days?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        smerchant,

        You may need to check date column to calculate the days in your dataset.

        Regards,