Power BI Dataset Stuck Refreshing and Won't Load

[volfied]

EDIT: The problem has been resolved.

------------------------------

Hi. My Power BI Dataset is stuck in a refresh. It wouldn't load into the Desktop app for a little while, then I kicked off the refresh to try to fix it. I have tried cancelling it to no effect. The PBI file the dataset is built on refreshes locally with no difficulty.

I hope this info from the Desktop app is enough to identify the dataset and the problem. Please let me know if you need anything additional. 

Feedback Type:
Frown (Error)

Timestamp:
2023-06-21T18:03:09.2646967Z

Local Time:
2023-06-21T14:03:09.2646967-04:00

Session ID:
12defb9c-23b0-49a2-b3dc-caa0e9892a07

Release:
June 2023

Product Version:
2.118.621.0 (23.06) (x64)

Stack Trace:
Javascript: Error
at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent)
at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.<>c__DisplayClass10_1.<GetModelMetadata>b__1(ExploreBaseEvent timedEvent)
at Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.<>c__DisplayClass4_0`1.<RunInActivity>b__0(ExploreBaseEvent activity)
at Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.RunInActivity(String activityName, Action`1 action)
at Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.RunInActivity[T](String activityName, Func`2 action)
at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.GetModelMetadata(ModelMetadataRequest request)
at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.GetConceptualSchema(ModelMetadataRequest request, ConceptualSchemaBuilderOptions builderOptions, ParseConceptualSchema parse)
at Microsoft.PowerBI.ReportingServicesHost.ReportingSession.GetConceptualSchema(String modelMetadataVersion, Nullable`1 translationsBehavior, ParseConceptualSchema parse)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.<>c__DisplayClass34_0.<GetConceptualSchema>b__0()
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.HandleModelRetrievalExceptions[T](Func`1 wrappedCall, ServiceErrorStatusCode statusCode)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetConceptualSchemaAndHandleExceptions(Func`1 getConceptualSchema, String maxModelMetadataVersion, ModelDaxCapabilities& daxCapabilities)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetConceptualSchema(IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, Nullable`1 translationsBehavior, ModelDaxCapabilities& daxCapabilities)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.<>c__DisplayClass27_0.<TryGetConceptualSchema>b__0()
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.TryGetStructureImpl[T](Int64 modelID, ServiceErrorExtractor extractor, Func`1 getStructure, Func`2 validateStructure, T& structure, ServiceError& serviceError)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.118.621.0","ModuleName":"","Component":"","Error":"Error","MethodDef":"","ErrorOffset":"-1:-1","ErrorCode":""}

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

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

Peak Virtual Memory:
69.8 GB

Private Memory:
419 MB

Peak Working Set:
731 MB

IE Version:
11.789.19041.0

User ID:
49377a0d-f58f-4ff2-9666-caa2e6dc21da

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

Telemetry Enabled:
True

AS Live Connection:
True

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_setLabelOnExportPdf
PBI_newCard

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_gitIntegration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[Anonymous]

Hi @volfied 

I am so glad to hear that your issue has been fixed . I will change the status to "Delivered" . Also, can you share your solution?

Best Regards,
Community Support Team _ Ailsa Tao

[volfied]

It just eventually resolved itself. Wasn't anything I did.