Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 3 Next »

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

  • No labels