Use of Semantic Data Model in PowerBI Desktop OneLake Data Hub does not display the table

[puramc]

I already updated the PowerBI Desktop to the latest update.

I created a semantic data model connecting to an Oracle database. We used a gateway pointing to correct datasource. If i try to use the web version of powerbi everything works fine. But when I use the PowerBI Desktop, at the bottom it says connected live to the Power BI semantic model but no table is being displayed.

Facts:

   Report and semantic data model is working fine in PowerBI WEB

   Cannot create report because semantic data model does not display any table

Additional 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.

True

The error as copied from the clipboard:

Feedback Type:
Frown (Error)

Timestamp:
2024-10-10T08:57:54.2009039Z

Local Time:
2024-10-10T16:57:54.2009039+08:00

Session ID:
edc2f169-fc6b-4af9-92b1-a5978b03e014

Release:
September 2024

Product Version:
2.136.1478.0 (24.09) (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.136.1478.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-GB)

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

Peak Virtual Memory:
70.5 GB

Private Memory:
569 MB

Peak Working Set:
1.05 GB

IE Version:
11.1.22621.0

User ID:
87288b99-9a13-4ed9-8868-bc75ee87342c

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_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_visualCalculationsAuthoring
PBI_desktopReportAuthoringCopilot

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

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

[Anonymous]

Hi @puramc 

According to the error message, you really don't have access to this semantic model or the semantic model doesn't exist. Did you make sure your account on Desktop, has access to that semantic model?

Best Regards,
Community Support Team _ Ailsa Tao

[puramc]

Hi,

• puramc successfully logged in PowerBI Desktop.
• puramc successfully created the report using PowerBI Desktop.
• puramc successfully published the report.
• puramc successfully opened report using PowerBI web.
• puramc successfully viewed the report.

I tried logging in as puramc and created a new report, i used the existing semantic data model that I previously created but gives out the error.

Thanks,

[Anonymous]

Hi @puramc 

There is no such thing as not being able to connect if the reports are all created using one account. Do you have any other semantic model to connect to other than this one?

Best Regards,
Community Support Team _ Ailsa Tao

[puramc]

Ok now. Let’s use screenshots.

Let use PowerBI Web first.

Login using my account.

Login using my account.

I clicked new report and clicked “Pick a published semantic model”

I clicked new report and clicked “Pick a published semantic model”

I used the BA_FUND semantic model that i created

I used the BA_FUND

And click auto-create report. As you can see, I have created a report successfully using PowerBI Web.

And click auto-create report. As you can see, I have created a report successfully using PowerBI Web.

Now, I’ll be using PowerBI Desktop.

I opened PowerBI Dekstop, logged in using my account and select “Get data from other sources”

I opened PowerBI Dekstop, logged in using my account and select “Get data from other sources”

Select Microsoft Fabric then Power BI semantic models

Select Microsoft Fabric then Power BI semantic models

Select the same BA_FUND semantic model that I created

Select the same BA_FUND semantic model that I created

After clicking “Connect” I saw Data panel is trying to show the table for this semantic model.

After clicking “Connect” I saw Data panel is trying to show the table for this semantic model.

It shows “Working  on it”

It even shows “Working on it”

At the status bar it says connected.

At the status bar it says connected.

Then this appeared.

Then this appeared.

Clicked “Report this issue”

Clicked “Report this issue”

[puramc]

To answer your previous post.

There is no such thing as not being able to connect if the reports are all created using one account.

That's what i thought. We are in sync here.

Do you have any other semantic model to connect to other than this one?

This is my first time to use semantic model and third time testing by creating and recreating but the problem persist. The model is connecting to an Oracle database. I have successfully installed the required apps to be able to connect to it using PowerBI Desktop and was able to create a report and publish it to the web.

[puramc]

Version of PowerBI Desktop