Excel.Interfaces.QueryLoadOptions interface
Represents a Power Query query.
Remarks
Properties
| $all | Specifying |
| error | Gets the query error message from when the query was last refreshed. |
| loaded |
Gets the query loaded to object type. |
| loaded |
Specifies if the query loaded to the data model. |
| name | Gets the name of the query. Query names cannot contain periods or quotation marks. |
| refresh |
Gets the date and time when the query was last refreshed. |
| rows |
Gets the number of rows that were loaded when the query was last refreshed. If last refresh has errors the value will be -1. |
Property Details
$all
Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
$all?: boolean;Property Value
boolean
error
Gets the query error message from when the query was last refreshed.
error?: boolean;Property Value
boolean
Remarks
loadedTo
Gets the query loaded to object type.
loadedTo?: boolean;Property Value
boolean
Remarks
loadedToDataModel
Specifies if the query loaded to the data model.
loadedToDataModel?: boolean;Property Value
boolean
Remarks
name
Gets the name of the query. Query names cannot contain periods or quotation marks.
name?: boolean;Property Value
boolean
Remarks
refreshDate
Gets the date and time when the query was last refreshed.
refreshDate?: boolean;Property Value
boolean
Remarks
rowsLoadedCount
Gets the number of rows that were loaded when the query was last refreshed. If last refresh has errors the value will be -1.
rowsLoadedCount?: boolean;Property Value
boolean