Duration Data Type and Blank Query Connection

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, 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.

Decimal data type.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.