Connecting via ODBC error on large datasets

[aspirationalbec]

I'm connecting an Oracle database via ODBC.

It is possible to connect smaller datasets or tables with a SQL query but am getting the following error message when connecting a large dataset:

Unexpected error: Container exited unexpectedly with code 0xC0000409. PID: 24920.
Used features: Odbc.DataSource/SQORA32.DLL/19.03.0000/Oracle/19.00.0000.
Details:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0xC0000409. PID: 24920.
Used features: Odbc.DataSource/SQORA32.DLL/19.03.0000/Oracle/19.00.0000. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0xC0000409. PID: 24920.
at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
at Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)
at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()
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_Value()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_Value()
at Microsoft.Mashup.Host.Document.Preview.PreviewEvaluation.<>c__DisplayClass22_0.<StartEvaluation>b__0(EvaluationResult2`1 result)

I've tried adjusting the fetchsize, cleared the cache. Any other ideas please?

[Anonymous]

Hi @aspirationalbec ,

During my investigation I have found users in the past who have had similar experiences to you .
The solution given by other forum users was:created a filtered pbix file that has only a snapshot of the data. Set up incremental refresh on it. Published and refreshed. That created the partitions.

For original post, you may refer to:Solved: Can't import large dataset in desktop and service ... - Microsoft Fabric Community

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@aspirationalbec , can you use advanced option and write a query and check if it loads data for a table