Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm using the NetSuite Suiteconnect ODBC driver in the Power Query Editor in Power BI and Excel. It will refresh OK, but I am unable to transform the data in the Power Query Editor. Not being able to do so makes Power BI unusable with this driver.
The code in the Advanced Editor is:
let
Source = Odbc.DataSource("dsn=NetSuite", [HierarchicalNavigation=true]),
#"XXXXXXXXXXXXXXXXXX Incorporated _Database" = Source{[Name="XXXXXXXXXXXXXXXXXX Incorporated",Kind="Database"]}[Data],
#"CAI - Reporting_Schema" = #"XXXXXXXXXXXXXXXXXX Incorporated_Database"{[Name="CAI - Reporting",Kind="Schema"]}[Data],
Account_Table = #"XXX - Reporting_Schema"{[Name="Account",Kind="Table"]}[Data]
in
Account_Table
The error message is "Index was outside the bounds of the array" followed by this code:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Index was outside the bounds of the array. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.
at Microsoft.Mashup.Engine1.Runtime.Keys.DictionaryStringKeys.get_Item(Int32 index)
at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQuery.ApplyStableOrder(OdbcQuery query)
at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQuery.<GetRows>b__57_0()
at Microsoft.Mashup.Engine1.Language.Query.SkipTakeEnumerable.GetEnumerator()
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Runtime.RetryQuery.RetryEnumerator.MoveNext()
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(String entryName, IEngineHost engineHost, IMessageChannel channel, Action action)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass17_0.<TryReportException>b__1()
at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(String entryName, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.BootstrapAppDomainManager.Execute(String[] argv)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |