none
[Expression Error] The import AnalysisServices.Database matches no exports. Did you miss a module reference? RRS feed

  • Question

  • Has anyone ever seen this error and/or know how to fix it?  it seems to happen when trying to update an Excel workbook in Excel 2016 using Power Query.  The error does not happen in Excel 2010 though?

    Any help would be greatly appreciated!

    Rich

    Wednesday, August 22, 2018 4:39 PM

Answers

  • So the issue turns out to be that the users are running on an older version of Power Query that does not include the AnalysisServices.Database function. Upgrading all instances of Excel to the same version of Power Query should resolve the issue.

    Ehren

    Friday, September 21, 2018 6:30 PM
    Owner

All replies

  • Hi Scullpa,

    That's really strange. Could you run the following inside PQ (by creating a new Blank Formula) and paste the results here?

    = Table.Sort(Table.SelectColumns(Table.SelectRows(Record.ToTable(#shared), each [Value] is function), {"Name"}), {"Name"})

    Also, if you could let us know your exact Excel and PQ versions, that would be helpful.

    Ehren

    Wednesday, August 22, 2018 9:20 PM
    Owner
  • This is the error message I receive from the user's desktop.

    An error occurred in the ‘Invoice Accruals’ query. Expression.Error: The import AnalysisServices.Database matches no exports. Did you miss a module reference?

    It seems as though it could be a version issue but if it is I don't know how to fix it as I installed the latest version of Power Query on the user's desktop and while 2010 recognizes the new version 2016 does not.  I should note that we have both Excel 2010 and Excel 2016 installed on all of our desktops due to some issues we have when just using Excel 2016 as this refresh works fine in Excel 2010.

    User Versions:

    Excel 2016:  MSO (16.0.4639.1000) 64 bit, Power Query 2.24.4065.1401 64 bit

    Excel 2010:  (14.0.6023.1000) 64 bit, Power Query 2.59.5135.201 64 bit

    For me, it works fine in Excel 2010 and in Excel 2016

    My Versions:

    Excel 2016:  MSO (16.0.4639.1000) 64 bit, Power Query 2.46.4732.721 64 bit

    Excel 2010:  (14.0.6023.1000) 64 bit, Power Query 2.49.4831.381 64 bit

    Thanks!

     

    Thursday, August 23, 2018 7:12 PM
  • Thanks. Could you let us know the result of running (in the user's Excel 2016) the M expression I provided above? Also, do you see the same error about AnalysisServices.Database in your copy of Excel 2016?

    Ehren

    Thursday, August 23, 2018 7:18 PM
    Owner
  • I do not get the same error when running in my Excel 2016.

    I was going to paste in a screenshot of what the M query returned but it said something about my account and that it has not been validated yet (whatever that means).  Anyway, the output is the creation of a Custom column and when I click on the table to expand it says that 'No columns were found.' 

    Let me know if that makes sense. 


    • Edited by Scullpa Thursday, August 23, 2018 8:39 PM Strange text in original post.
    Thursday, August 23, 2018 8:15 PM
  • Hi Scullpa. When you evaluate the M expression I provided above, the result should look something like this:

    You can right-click on the column, Copy the data, and paste it here, so you shouldn't have to post a screenshot.

    It sounds like you're seeing something different. Can you try again and let us know?

    Ehren



    Thursday, August 30, 2018 10:59 PM
    Owner
  • Here's what I get...

    Name
    Access.Database
    ActiveDirectory.Domains
    AdoDotNet.DataSource
    AdoDotNet.Query
    AnalysisServices.Database
    AnalysisServices.Databases
    AzureStorage.Blobs
    AzureStorage.Tables
    Binary.Buffer
    Binary.Combine
    Binary.Compress
    Binary.Decompress
    Binary.From
    Binary.FromList
    Binary.FromText
    Binary.Length
    Binary.ToList
    Binary.ToText
    BinaryFormat.7BitEncodedSignedInteger
    BinaryFormat.7BitEncodedUnsignedInteger
    BinaryFormat.Binary
    BinaryFormat.Byte
    BinaryFormat.ByteOrder
    BinaryFormat.Choice
    BinaryFormat.Decimal
    BinaryFormat.Double
    BinaryFormat.Group
    BinaryFormat.Length
    BinaryFormat.List
    BinaryFormat.Null
    BinaryFormat.Record
    BinaryFormat.SignedInteger16
    BinaryFormat.SignedInteger32
    BinaryFormat.SignedInteger64
    BinaryFormat.Single
    BinaryFormat.Text
    BinaryFormat.Transform
    BinaryFormat.UnsignedInteger16
    BinaryFormat.UnsignedInteger32
    BinaryFormat.UnsignedInteger64
    Byte.From
    Character.FromNumber
    Character.ToNumber
    Combiner.CombineTextByDelimiter
    Combiner.CombineTextByEachDelimiter
    Combiner.CombineTextByLengths
    Combiner.CombineTextByPositions
    Combiner.CombineTextByRanges
    Comparer.Equals
    Comparer.FromCulture
    Comparer.Ordinal
    Comparer.OrdinalIgnoreCase
    Csv.Document
    Cube.AddAndExpandDimensionColumn
    Cube.AddMeasureColumn
    Cube.ApplyParameter
    Cube.AttributeMemberId
    Cube.CollapseAndRemoveColumns
    Cube.Dimensions
    Cube.DisplayFolders
    Cube.Measures
    Cube.Parameters
    Cube.Transform
    Currency.From
    DB2.Database
    Date.AddDays
    Date.AddMonths
    Date.AddQuarters
    Date.AddWeeks
    Date.AddYears
    Date.Day
    Date.DayOfWeek
    Date.DayOfWeekName
    Date.DayOfYear
    Date.DaysInMonth
    Date.EndOfDay
    Date.EndOfMonth
    Date.EndOfQuarter
    Date.EndOfWeek
    Date.EndOfYear
    Date.From
    Date.FromText
    Date.IsInCurrentDay
    Date.IsInCurrentMonth
    Date.IsInCurrentQuarter
    Date.IsInCurrentWeek
    Date.IsInCurrentYear
    Date.IsInNextDay
    Date.IsInNextMonth
    Date.IsInNextNDays
    Date.IsInNextNMonths
    Date.IsInNextNQuarters
    Date.IsInNextNWeeks
    Date.IsInNextNYears
    Date.IsInNextQuarter
    Date.IsInNextWeek
    Date.IsInNextYear
    Date.IsInPreviousDay
    Date.IsInPreviousMonth
    Date.IsInPreviousNDays
    Date.IsInPreviousNMonths
    Date.IsInPreviousNQuarters
    Date.IsInPreviousNWeeks
    Date.IsInPreviousNYears
    Date.IsInPreviousQuarter
    Date.IsInPreviousWeek
    Date.IsInPreviousYear
    Date.IsInYearToDate
    Date.IsLeapYear
    Date.Month
    Date.MonthName
    Date.QuarterOfYear
    Date.StartOfDay
    Date.StartOfMonth
    Date.StartOfQuarter
    Date.StartOfWeek
    Date.StartOfYear
    Date.ToRecord
    Date.ToText
    Date.WeekOfMonth
    Date.WeekOfYear
    Date.Year
    DateTime.AddZone
    DateTime.Date
    DateTime.FixedLocalNow
    DateTime.From
    DateTime.FromFileTime
    DateTime.FromText
    DateTime.IsInCurrentHour
    DateTime.IsInCurrentMinute
    DateTime.IsInCurrentSecond
    DateTime.IsInNextHour
    DateTime.IsInNextMinute
    DateTime.IsInNextNHours
    DateTime.IsInNextNMinutes
    DateTime.IsInNextNSeconds
    DateTime.IsInNextSecond
    DateTime.IsInPreviousHour
    DateTime.IsInPreviousMinute
    DateTime.IsInPreviousNHours
    DateTime.IsInPreviousNMinutes
    DateTime.IsInPreviousNSeconds
    DateTime.IsInPreviousSecond
    DateTime.LocalNow
    DateTime.Time
    DateTime.ToRecord
    DateTime.ToText
    DateTimeZone.FixedLocalNow
    DateTimeZone.FixedUtcNow
    DateTimeZone.From
    DateTimeZone.FromFileTime
    DateTimeZone.FromText
    DateTimeZone.LocalNow
    DateTimeZone.RemoveZone
    DateTimeZone.SwitchZone
    DateTimeZone.ToLocal
    DateTimeZone.ToRecord
    DateTimeZone.ToText
    DateTimeZone.ToUtc
    DateTimeZone.UtcNow
    DateTimeZone.ZoneHours
    DateTimeZone.ZoneMinutes
    Decimal.From
    Diagnostics.ActivityId
    Diagnostics.Trace
    DirectQueryCapabilities.From
    Double.From
    Duration.Days
    Duration.From
    Duration.FromText
    Duration.Hours
    Duration.Minutes
    Duration.Seconds
    Duration.ToRecord
    Duration.ToText
    Duration.TotalDays
    Duration.TotalHours
    Duration.TotalMinutes
    Duration.TotalSeconds
    Embedded.Value
    Error.Record
    Excel.CurrentWorkbook
    Excel.Workbook
    Exchange.Contents
    Expression.Constant
    Expression.Evaluate
    Expression.Identifier
    Facebook.Graph
    File.Contents
    Folder.Contents
    Folder.Files
    Function.Invoke
    Function.InvokeAfter
    Function.IsDataSource
    HdInsight.Containers
    HdInsight.Contents
    HdInsight.Files
    Hdfs.Contents
    Hdfs.Files
    Informix.Database
    Int16.From
    Int32.From
    Int64.From
    Int8.From
    Json.Document
    Json.FromValue
    Lines.FromBinary
    Lines.FromText
    Lines.ToBinary
    Lines.ToText
    List.Accumulate
    List.AllTrue
    List.Alternate
    List.AnyTrue
    List.Average
    List.Buffer
    List.Combine
    List.Contains
    List.ContainsAll
    List.ContainsAny
    List.Count
    List.Covariance
    List.DateTimeZones
    List.DateTimes
    List.Dates
    List.Difference
    List.Distinct
    List.Durations
    List.FindText
    List.First
    List.FirstN
    List.Generate
    List.InsertRange
    List.Intersect
    List.IsDistinct
    List.IsEmpty
    List.Last
    List.LastN
    List.MatchesAll
    List.MatchesAny
    List.Max
    List.MaxN
    List.Median
    List.Min
    List.MinN
    List.Mode
    List.Modes
    List.NonNullCount
    List.Numbers
    List.PositionOf
    List.PositionOfAny
    List.Positions
    List.Product
    List.Random
    List.Range
    List.RemoveFirstN
    List.RemoveItems
    List.RemoveLastN
    List.RemoveMatchingItems
    List.RemoveNulls
    List.RemoveRange
    List.Repeat
    List.ReplaceMatchingItems
    List.ReplaceRange
    List.ReplaceValue
    List.Reverse
    List.Select
    List.Single
    List.SingleOrDefault
    List.Skip
    List.Sort
    List.StandardDeviation
    List.Sum
    List.Times
    List.Transform
    List.TransformMany
    List.Union
    List.Zip
    Logical.From
    Logical.FromText
    Logical.ToText
    Marketplace.Subscriptions
    MySQL.Database
    Number.Abs
    Number.Acos
    Number.Asin
    Number.Atan
    Number.Atan2
    Number.BitwiseAnd
    Number.BitwiseNot
    Number.BitwiseOr
    Number.BitwiseShiftLeft
    Number.BitwiseShiftRight
    Number.BitwiseXor
    Number.Combinations
    Number.Cos
    Number.Cosh
    Number.Exp
    Number.Factorial
    Number.From
    Number.FromText
    Number.IntegerDivide
    Number.IsEven
    Number.IsNaN
    Number.IsOdd
    Number.Ln
    Number.Log
    Number.Log10
    Number.Mod
    Number.Permutations
    Number.Power
    Number.Random
    Number.RandomBetween
    Number.Round
    Number.RoundAwayFromZero
    Number.RoundDown
    Number.RoundTowardZero
    Number.RoundUp
    Number.Sign
    Number.Sin
    Number.Sinh
    Number.Sqrt
    Number.Tan
    Number.Tanh
    Number.ToText
    OData.Feed
    Odbc.DataSource
    Odbc.Query
    OleDb.DataSource
    OleDb.Query
    Oracle.Database
    Percentage.From
    PostgreSQL.Database
    RData.FromBinary
    Record.AddField
    Record.Combine
    Record.Field
    Record.FieldCount
    Record.FieldNames
    Record.FieldOrDefault
    Record.FieldValues
    Record.FromList
    Record.FromTable
    Record.HasFields
    Record.RemoveFields
    Record.RenameFields
    Record.ReorderFields
    Record.SelectFields
    Record.ToList
    Record.ToTable
    Record.TransformFields
    Replacer.ReplaceText
    Replacer.ReplaceValue
    Resource.Access
    RowExpression.Column
    RowExpression.From
    Salesforce.Data
    Salesforce.Reports
    SapHana.Database
    SharePoint.Contents
    SharePoint.Files
    SharePoint.Tables
    Single.From
    Soda.Feed
    Splitter.SplitByNothing
    Splitter.SplitTextByAnyDelimiter
    Splitter.SplitTextByDelimiter
    Splitter.SplitTextByEachDelimiter
    Splitter.SplitTextByLengths
    Splitter.SplitTextByPositions
    Splitter.SplitTextByRanges
    Splitter.SplitTextByRepeatedLengths
    Splitter.SplitTextByWhitespace
    Sql.Database
    Sql.Databases
    SqlExpression.SchemaFrom
    SqlExpression.ToExpression
    Sybase.Database
    Table.AddColumn
    Table.AddIndexColumn
    Table.AddJoinColumn
    Table.AddKey
    Table.AggregateTableColumn
    Table.AlternateRows
    Table.Buffer
    Table.Column
    Table.ColumnCount
    Table.ColumnNames
    Table.ColumnsOfType
    Table.Combine
    Table.CombineColumns
    Table.Contains
    Table.ContainsAll
    Table.ContainsAny
    Table.DemoteHeaders
    Table.Distinct
    Table.DuplicateColumn
    Table.ExpandListColumn
    Table.ExpandRecordColumn
    Table.ExpandTableColumn
    Table.FillDown
    Table.FillUp
    Table.FilterWithDataTable
    Table.FindText
    Table.First
    Table.FirstN
    Table.FirstValue
    Table.FromColumns
    Table.FromList
    Table.FromPartitions
    Table.FromRecords
    Table.FromRows
    Table.FromValue
    Table.Group
    Table.HasColumns
    Table.InsertRows
    Table.IsDistinct
    Table.IsEmpty
    Table.Join
    Table.Keys
    Table.Last
    Table.LastN
    Table.MatchesAllRows
    Table.MatchesAnyRows
    Table.Max
    Table.MaxN
    Table.Min
    Table.MinN
    Table.NestedJoin
    Table.Partition
    Table.PartitionValues
    Table.Pivot
    Table.PositionOf
    Table.PositionOfAny
    Table.PrefixColumns
    Table.Profile
    Table.PromoteHeaders
    Table.Range
    Table.RemoveColumns
    Table.RemoveFirstN
    Table.RemoveLastN
    Table.RemoveMatchingRows
    Table.RemoveRows
    Table.RemoveRowsWithErrors
    Table.RenameColumns
    Table.ReorderColumns
    Table.Repeat
    Table.ReplaceErrorValues
    Table.ReplaceKeys
    Table.ReplaceMatchingRows
    Table.ReplaceRelationshipIdentity
    Table.ReplaceRows
    Table.ReplaceValue
    Table.ReverseRows
    Table.RowCount
    Table.Schema
    Table.SelectColumns
    Table.SelectRows
    Table.SelectRowsWithErrors
    Table.SingleRow
    Table.Skip
    Table.Sort
    Table.SplitColumn
    Table.ToColumns
    Table.ToList
    Table.ToRecords
    Table.ToRows
    Table.TransformColumnNames
    Table.TransformColumnTypes
    Table.TransformColumns
    Table.TransformRows
    Table.Transpose
    Table.Unpivot
    Table.UnpivotOtherColumns
    Table.View
    Tables.GetRelationships
    Teradata.Database
    Text.AfterDelimiter
    Text.At
    Text.BeforeDelimiter
    Text.BetweenDelimiters
    Text.Clean
    Text.Combine
    Text.Contains
    Text.End
    Text.EndsWith
    Text.Format
    Text.From
    Text.FromBinary
    Text.Insert
    Text.Length
    Text.Lower
    Text.Middle
    Text.NewGuid
    Text.PadEnd
    Text.PadStart
    Text.PositionOf
    Text.PositionOfAny
    Text.Proper
    Text.Range
    Text.Remove
    Text.RemoveRange
    Text.Repeat
    Text.Replace
    Text.ReplaceRange
    Text.Split
    Text.SplitAny
    Text.Start
    Text.StartsWith
    Text.ToBinary
    Text.ToList
    Text.Trim
    Text.TrimEnd
    Text.TrimStart
    Text.Upper
    Time.EndOfHour
    Time.From
    Time.FromText
    Time.Hour
    Time.Minute
    Time.Second
    Time.StartOfHour
    Time.ToRecord
    Time.ToText
    Type.AddTableKey
    Type.ClosedRecord
    Type.Facets
    Type.ForFunction
    Type.ForRecord
    Type.FunctionParameters
    Type.FunctionRequiredParameters
    Type.FunctionReturn
    Type.Is
    Type.IsNullable
    Type.IsOpenRecord
    Type.ListItem
    Type.NonNullable
    Type.OpenRecord
    Type.RecordFields
    Type.ReplaceFacets
    Type.ReplaceTableKeys
    Type.TableColumn
    Type.TableKeys
    Type.TableRow
    Type.TableSchema
    Type.Union
    Uri.BuildQueryString
    Uri.Combine
    Uri.EscapeDataString
    Uri.Parts
    Value.Add
    Value.As
    Value.Compare
    Value.Divide
    Value.Equals
    Value.Firewall
    Value.FromText
    Value.Is
    Value.Metadata
    Value.Multiply
    Value.NativeQuery
    Value.NullableEquals
    Value.RemoveMetadata
    Value.ReplaceMetadata
    Value.ReplaceType
    Value.ResourceExpression
    Value.Subtract
    Value.Type
    Variable.Value
    Web.Contents
    Web.Page
    Xml.Document
    Xml.Tables

    Tuesday, September 4, 2018 6:04 PM
  • Ok, thanks. Is this from the user's desktop who is getting the Expression.Error?

    Ehren

    Tuesday, September 4, 2018 6:11 PM
    Owner
  • No this is from mine.  I'm working on getting it from a user's desktop.  The gentleman I was troubleshooting this with is out until next Monday but I know there are others in my organization that is having the issue so I'm waiting to hear back from one of them.  I'll keep you posted.
    Tuesday, September 4, 2018 6:22 PM
  • I just tried to run it from a user's desktop and it won't even let me add that formula at all. PQ just throws the above error as soon as I open PQ and doesn't allow me to add a new formula like I was able to do on my desktop.
    Tuesday, September 4, 2018 6:39 PM
  • Hi there. Would you be available for a Skype call to walk through the issue on the user's machine? If so, please send me a private message on the Power BI Community. My user profile is: https://community.powerbi.com/t5/user/viewprofilepage/user-id/33215

    Ehren

    Thursday, September 13, 2018 5:04 PM
    Owner
  • So the issue turns out to be that the users are running on an older version of Power Query that does not include the AnalysisServices.Database function. Upgrading all instances of Excel to the same version of Power Query should resolve the issue.

    Ehren

    Friday, September 21, 2018 6:30 PM
    Owner
  • Hey,

    I just got the same error message, when trying to import several csv files via macro. I use Office365 with the newest version of Excel. I also can't install Power Query manually, as it will tell me, that it's already integrated into Excel.

    Sunday, January 12, 2020 5:09 PM