Forum Discussion

Black783's avatar
Black783
Frequent Visitor
8 years ago
Solved

power bi error container exited unexpectedly with code dxc0000374.

Feedback Type:
Frown (Error)

Timestamp:
2018-09-05T11:21:50.7399854Z

Local Time:
2018-09-05T07:21:50.7399854-04:00

Session ID:
cf4f968c-0df3-4937-a172-d19cf6a9eb06

Release:
August 2018

Product Version:
2.61.5192.601 (18.08) (x64)

Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0xC0000374.
Used features: Microsoft.ACE.OLEDB.12.0. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0xC0000374.
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_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)

OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461808]

Peak Virtual Memory:
38 GB

Private Memory:
333 MB

Peak Working Set:
486 MB

IE Version:
11.228.17134.0

User ID:
8666c9a2-dc78-4223-ae6f-b744eea8daa5

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\joem\Microsoft\Power BI Desktop Store App\FrownSnapShot1198552171.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_newFromWeb
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_variationUIChange
PBI_canvasTooltips
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_compositeModels
PBI_DB2DQ

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Reports
  • Black783's avatar
    Black783
    8 years ago

    The issue is resolved.  I'm using Power BI for an Access application.  I compacted and repaired the database and the error cleared up.

     

    Thanks,

    Joe

4 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Black783,

     

    Which action do you take then error occurs in Power BI desktop? Would you please share detail information. 

     

    Also please clear desktop cache ( C:\Users\<user>\AppData\Local\Microsoft\Power BI Desktop\Cache ) then test again to see if the same issue occurs. 

     

    Best Regards,
    Qiuyun Yu 

  • Black783's avatar
    Black783
    Frequent Visitor
    8 years ago

    The issue is resolved.  I'm using Power BI for an Access application.  I compacted and repaired the database and the error cleared up.

     

    Thanks,

    Joe

  • JUAN2's avatar
    JUAN2
    New Member
    1 year ago

    I solved a similar issue with a 6 millions rows table.

     

    2 options:

     

    1) get all info by blocks:

     

    =let
    // Define the function to get a page of data
    GetPage = (Offset as number, Limit as number) as table =>
    let
    Source = Odbc.DataSource("dsn=[NAME]", [HierarchicalNavigation=true]),
    Query = Odbc.Query("dsn=[NAME]", Text.Format("SELECT * FROM [TABLE] LIMIT #{0} OFFSET #{1}", {Limit, Offset}))
    in
    Query,

    // Define the block size
    BlockSize = 100000,

    // Define the number of parallel queries
    ParallelQueries = 10,

    // Function to get data in parallel
    GetParallelData = (StartOffset as number, EndOffset as number, Step as number) as list =>
    let
    Offsets = List.Generate(() => StartOffset, each _ < EndOffset, each _ + Step),
    Tables = List.Transform(Offsets, each GetPage(_, Step))
    in
    Tables,

    // Get data in parallel
    DataBlocks = List.Transform({0..(ParallelQueries-1)}, each GetParallelData(_ * BlockSize, 3000000, BlockSize)),

    // Combine all tables into one
    CombinedResult = Table.Combine(List.Combine(DataBlocks))
    in
    CombinedResult

     

     

    2) get only needed fields at once:

     

    =let
    Source = Odbc.DataSource("dsn=[NAME]", [HierarchicalNavigation=true]),
    Query = Odbc.Query("dsn=[NAME]", "SELECT column1, column2, column3 FROM [TABLE]")
    in
    Query