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

If you select the Blank Query Connection, to use ​ and ​ 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.gifDuration in seconds.gif

  • 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.gifDuration as a string.gif