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

Decimal data type.gifDuration in seconds.gif

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

Display value.gifDuration as a string.gif