/
Duration Data Type and Blank Query Connection

Duration Data Type and Blank Query Connection

Owned by Liliia Ostrovska
Last updated: Jan 09, 2025
2 min read

The Blank Query Connection doesn’t support Duration data type. It cannot convert this data type to PBI types.

If you select the Blank Query Connection, to use ​string and ​decimal data types to prevent errors is significant.

When exporting fields that contain duration data type, please enable any of the two options below.

 

  • Enable the Duration in seconds option and the exported data will be displayed as 28435141.

sn_duration_in_seconds_enabled_2.gif
Duration in seconds.gif
Duration as a decimal (seconds)

 

  • Enable the Use display value option and the exported data will be displayed as 329 Days 2 Hours 30 Minutes.

 

How to Connect to Power BI if ServiceNow Uses MFA/2FA/SSO?

Display value.gif
Duration as a string.gif
Duration as a string

 

 

Related content