excel.interfaces.queryloadoptions.yml

### YamlMime:TSType
name: Excel.Interfaces.QueryLoadOptions
uid: 'excel!Excel.Interfaces.QueryLoadOptions:interface'
package: excel!
fullName: Excel.Interfaces.QueryLoadOptions
summary: Represents a Power Query query.
remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: $all
    uid: 'excel!Excel.Interfaces.QueryLoadOptions#$all:member'
    package: excel!
    fullName: $all
    summary: >-
      Specifying `$all` for the LoadOptions loads all the scalar properties (e.g.: `Range.address`<!-- -->) but not the
      navigational properties (e.g.: `Range.format.fill.color`<!-- -->).
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: '$all?: boolean;'
      return:
        type: boolean
  - name: error
    uid: 'excel!Excel.Interfaces.QueryLoadOptions#error:member'
    package: excel!
    fullName: error
    summary: Gets the query error message from when the query was last refreshed.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'error?: boolean;'
      return:
        type: boolean
  - name: loadedTo
    uid: 'excel!Excel.Interfaces.QueryLoadOptions#loadedTo:member'
    package: excel!
    fullName: loadedTo
    summary: Gets the query loaded to object type.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'loadedTo?: boolean;'
      return:
        type: boolean
  - name: loadedToDataModel
    uid: 'excel!Excel.Interfaces.QueryLoadOptions#loadedToDataModel:member'
    package: excel!
    fullName: loadedToDataModel
    summary: Specifies if the query loaded to the data model.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'loadedToDataModel?: boolean;'
      return:
        type: boolean
  - name: name
    uid: 'excel!Excel.Interfaces.QueryLoadOptions#name:member'
    package: excel!
    fullName: name
    summary: Gets the name of the query. Query names cannot contain periods or quotation marks.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'name?: boolean;'
      return:
        type: boolean
  - name: refreshDate
    uid: 'excel!Excel.Interfaces.QueryLoadOptions#refreshDate:member'
    package: excel!
    fullName: refreshDate
    summary: Gets the date and time when the query was last refreshed.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'refreshDate?: boolean;'
      return:
        type: boolean
  - name: rowsLoadedCount
    uid: 'excel!Excel.Interfaces.QueryLoadOptions#rowsLoadedCount:member'
    package: excel!
    fullName: rowsLoadedCount
    summary: >-
      Gets the number of rows that were loaded when the query was last refreshed. If last refresh has errors the value
      will be -1.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'rowsLoadedCount?: boolean;'
      return:
        type: boolean