/
Duration Data Type and Blank Query Connection
Duration Data Type and Blank Query Connection
- Liliia Ostrovska
Owned by Liliia Ostrovska
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.
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.