Internal error DirectQueryUnexpectedEndOfStream.

[sherry_amelse]

Can anyone help me figure out how to resolve this error?  It worked fine before but I haven't been able to get this dataset to refresh for over a month and I'm struggling to figure out what's causing the problem.

Internal error DirectQueryUnexpectedEndOfStream.

Microsoft.Mashup.Host.Document.Evaluation.ErrorEvaluationResult

True

Here are the details:

Feedback Type:
Frown (Error)

Timestamp:
2024-07-15T00:48:26.6969722Z

Local Time:
2024-07-14T19:48:26.6969722-05:00

Session ID:
8897082f-28dc-4d07-a918-e087308e33a5

Release:
June 2024

Product Version:
2.130.930.0 (24.06) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
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)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.130.930.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Host.Document.SerializedException - Microsoft.Mashup.Host.Document.Evaluation.ErrorEvaluationResult","MethodDef":"OnException","ErrorOffset":"","ErrorCode":""}

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

CLR Version:
4.8 or later [Release Number = 533320]

Peak Virtual Memory:
113 GB

Private Memory:
1.5 GB

Peak Working Set:
1.67 GB

IE Version:
11.1.22621.0

User ID:
d3d517a6-3c0d-4258-bf4c-524cd43e0774

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

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_angularRls
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_EimLessElevatedUser
PBI_mobileAutoReportLayout
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_generateMeasureDescriptionsButton
PBI_desktopReportAuthoringCopilot

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_publishDialogsSupportSubfolders
PBI_tmdlInDataset
PBI_enhancedReportFormat
PBI_qnaImproveLsdlCopilot
PBI_visualCalculationsAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
250%

Supported Services:
Power BI

I really appreciate any advice that can help 

[Anonymous]

Hi @sherry_amelse ,

Can you confirm if this issue also exists in Power BI Service?
According to the error message you provided, it may be due to a problematic calculated column in your report, please check your report and try again.

Best regards.
Community Support Team_Caitlyn

[sherry_amelse]

Yes it also exists in Power BI Service.  Thank you for the tip about the possibility that it's caused by a calculated column.  That gives me some direction so I will look into that a bit more.  I've checked all my tables in power query and they all seem to be loading fine regardless of date filters.  When I try to refresh the report, it loads 5 of 7 tables and then gets stuck at 5600ish records in the 6th table.  Everything worked fine until 6/7/24 and then it just stopped refreshing. Thank you again for your suggestion.  I'll update if I find the issue.