Power BI Desktop Report Unable to Connect to Data Model in Power BI Service

[pa_pbi]

Hello,

I keep getting the error below whenever I open a pbix file on desktop that is connected to a data model in PBI service. Also it has been taking a very long time to open even small pbix files on desktop. These issues just began occurring receently since last week sporadically. The error message gets resolved after manually refreshing a report pbix file, but the wasted time dealing with these issues is accumulating. Is there a bug due to recent PBI desktop app updates? I have the August 2024 version and no other changes were made to my environment.

I have access, permissions and the models have not been deleted. I have tried other semantic models, none of them is working.

The problem is only in Desktop. Everything works fine in Service.

Error Message:
We couldn't connect to your model in the Power BI Service. The dataset may have been deleted, renamed, moved, or it is possible that you don't have permission to access it.

Feedback Type:
Frown (Error)

Timestamp:
2024-09-19T17:05:54.3986193Z

Local Time:
2024-09-19T13:05:54.3986193-04:00

Release:
August 2024

Product Version:
2.135.7627.0 (24.08) (x64)

Stack Trace:
Host:
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__DisplayClass38_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__DisplayClass31_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)

Javascript&colon;ShowErrorDialog
at ErrorHostService.ShowErrorDialog(args)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.135.7627.0","ModuleName":null,"Component":"Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.<>c__DisplayClass10_1","Error":null,"MethodDef":"<GetModelMetadata>b__1","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:
71.4 GB

Private Memory:
619 MB

Peak Working Set:
1.08 GB

IE Version:
11.1.22621.0

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

Telemetry Enabled:
True

AS Live Connection:
True

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_onObject
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_qnaImproveLsdlCopilot
PBI_generateMeasureDescriptionsButton
PBI_visualCalculationsAuthoring
PBI_desktopReportAuthoringCopilot

Disabled Preview Features:
PBI_odspSaveBackgroundUpload
PBI_publishDialogsSupportSubfolders
PBI_tmdlInDataset
PBI_enhancedReportFormat

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[Anonymous]

Hi @pa_pbi 

Power BI Desktop has been updated to version : 2.135.7627.0 (9/20/2024) . Please update your PBI Desktop to the latest version and then try to connect to data model again . You need to uninstall the PBI Desktop program in the Control Panel and then download the latest installer from Download Center to install it.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,
Community Support Team _ Ailsa Tao

[pa_pbi]

Yes, that helped, thanks! I wonder if the issues were occurring while Microsoft was working on updating/releasing the new version, since even before installing the new version, files were opening normally again today. Either way, glad the issue is resolved.

[Anonymous]

Hi @pa_pbi 

Microsoft store had a bit of a problem updating the program, but it's been fixed later. Glad your problem has been fixed. I will change the status to "Delivered" .

Best Regards,
Community Support Team _ Ailsa Tao