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 1451606537.
-
Enable the Use display value option and the exported data will be displayed as 16801 Days 2 Minutes.
