Forum Discussion

RakeshP's avatar
RakeshP
Helper I
10 years ago
Solved

Having issues with Connect to Oracle database

Hi ALL,   I am trying to connect to oracle database from Power BI Desktop(PBID), but it is throwing below error.   Unable to connect   we encountered an error while trying to connect   Detail...
Need Help
pqian's avatar
pqian
Microsoft Employee
10 years ago

leeann_g the client version need not match the server version. I think this is the version you want:

 


ODAC 12c Release 4 and Oracle Developer Tools for Visual Studio (12.1.0.2.4)
Download the File [Released October 5, 2015]
Download ODTwithODAC121024.zip 304 MB (319,813,071 bytes)

leeann_g's avatar
leeann_g
Frequent Visitor
10 years ago

That worked after removing all other versions, and making sure that I had the x64 version, of course. Still encountering some other issues at the query execution and filtering level, but that helped me over the connection hurdle. Thank you!

 

This would be a great thing to have included in the Prerequisites checklist or in the installation package for PowerBI itself.

  • pqian's avatar
    pqian
    Microsoft Employee
    10 years ago

    leeann_g What are some of the query execution issues? We'd be interested to hear.

     

    Unfortunately we cannot bundle Oracle drivers in PBI desktop (licensing issues). However, we'll be updating the FW link you get when the driver is missing, so that it points to the right address.

    • leeann_g's avatar
      leeann_g
      Frequent Visitor
      10 years ago

      I was spending excessive amounts of time getting through data filtering items. And each time I created a data filter on a column it would begin to refresh all data before allowing me to move on. This is extremely time consuming and disruptive if someone has multiple filters to apply.

       

      I think maybe some of the issues with editing queries, filtering, and inter-step data refresh might be solved with the latest PBI release. Need to test and will update thread with results!

    • leeann_g's avatar
      leeann_g
      Frequent Visitor
      10 years ago

      This is an example of an issue/error I am experiencing -- when filtering a date field from my data source, then selecting Month > Last Month. It appears to be unable to handle the date format we are using.

       

      I'm also attemting to execute the same query from the Added Column "Date" using the Date Filter = Month > Last Month.

       

      Error Message:

      Microsoft.Mashup.Engine1.Runtime.Library+Date+StartOfMonthFunctionValue

      Stack Trace:

      Microsoft.Mashup.Evaluator.Interface.ErrorException: Microsoft.Mashup.Engine1.Runtime.Library+Date+StartOfMonthFunctionValue ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Microsoft.Mashup.Engine1.Runtime.Library+Date+StartOfMonthFunctionValue ---> System.InvalidOperationException: Microsoft.Mashup.Engine1.Runtime.Library+Date+StartOfMonthFunctionValue
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitInvocation(IInvocationExpression invocation)
      at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
      at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.Visit(Object node)
      at Microsoft.Mashup.Engine1.Library.Oracle.OracleAstCreator.CreateToDate(IInvocationExpression invocation)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitInvocation(IInvocationExpression invocation)
      at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node, TypeValue type)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.CreateLogicalOperation(BinaryLogicalOperator predicate, IBinaryExpression binary)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitBinary(IBinaryExpression binary)
      at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
      at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.Visit(Object node)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.CreateConditionExpression(IExpression expression)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitBinary(IBinaryExpression binary)
      at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node, TypeValue type)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitInvocation(IInvocationExpression invocation)
      at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node, TypeValue type)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitInvocation(IInvocationExpression invocation)
      at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node, TypeValue type)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.CreateListSelect(IInvocationExpression invocation)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitInvocation(IInvocationExpression invocation)
      at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node, TypeValue type)
      at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node)
      at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.Compile(Query originalQuery, IExpression expression, LogicalAstToCachedTypeflowResultCursor cursor)
      at Microsoft.Mashup.Engine1.Library.Common.QueryResultTableValue.get_Type()
      at Microsoft.Mashup.Engine1.Library.Common.ExternalQueryProcessor.ApplyTake(Query originalQuery, Value input, IExpression takeQuery)
      at Microsoft.Mashup.Engine1.Library.Common.ExternalQueryProcessor.Invoke(Query originalQuery, IExpression expression)
      at Microsoft.Mashup.Engine1.Language.Query.QueryFolder.ExpressionTableValue.Take(Query query, RowCount count)
      at Microsoft.Mashup.Engine1.Language.Query.QueryFolder.ExpressionTableValue.SkipTake(SkipTakeQuery query)
      at Microsoft.Mashup.Engine1.Language.Query.QueryFolder.VisitSkipTake(SkipTakeQuery query)
      at Microsoft.Mashup.Engine1.Language.Query.QueryFolder.Fold(Query query)
      at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetEnumerator()
      at Microsoft.Mashup.Engine1.Runtime.TableValue.Microsoft.Mashup.Engine.Interface.ITableValue.GetEnumerator()
      at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
      at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
      at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass5.<RunStub>b__3()
      at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
      --- End of inner exception stack trace ---
      at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IHostTrace trace, Action action)
      at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
      at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
      at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
      at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass32`1.<OnBeginGetResult>b__2f()
      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.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__DisplayClass15.<CreateAction>b__14(Object o)
      at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
      at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
      --- 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.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

      Invocation Stack Trace:

      at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
      at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
      at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
      at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
      at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
      at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
      at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
      at System.Delegate.DynamicInvokeImpl(Object[] args)
      at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
      at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
      at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
      at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
      at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
      at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
      at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
      at System.Windows.Forms.Control.WndProc(Message& m)
      at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
      at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
      at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
      at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
      at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
      at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
      at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
      at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
      at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
      at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
      at Microsoft.PowerBI.Client.Program.Main(String[] args)

       

      • pqian's avatar
        pqian
        Microsoft Employee
        10 years ago

        leeann_g Can you post the Query's full expression here? (View->Advance Query Editor)

  • lynchc's avatar
    lynchc
    New Member
    7 years ago

    Where did you delete the old versions?

    • gusdcruz's avatar
      gusdcruz
      Helper I
      7 years ago

      I simply unistalled the software and installed the lastest version from the Power BI website.