Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
afterlanding
Regular Visitor

Couldn't load model schema - oracle db 12

Hello, when I try to establish direct query connection with oradb12, I've getting error 'Couldn't load model schema'

If i try to swith to import mode - everything is ok.

 

How can I solve this problem? 

 

Logs from Power BI and trace from DB when I get error: https://drive.google.com/open?id=1uoOcJ4g-U7qPzcGGpjM2L40gVDwqlb0Z

 

Copy from error message:

Spoiler
Feedback Type:
Frown (Error)

Timestamp:
2018-09-07T03:36:42.1815466Z

Local Time:
2018-09-07T10:36:42.1815466+07:00

Session ID:
abb9dd08-b254-4050-97ed-2bb6521f6c7b

Release:
August 2018

Product Version:
2.61.5192.601 (18.08) (x64)

Error Message:
Не удалось загрузить схему модели.

OS Version:
Microsoft Windows NT 10.0.14393.0 (x64 ru-RU)

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

Peak Virtual Memory:
34.2 GB

Private Memory:
588 MB

Peak Working Set:
719 MB

IE Version:
11.2430.14393.0

User ID:
fdf30d0c-a44f-43f8-b8bf-cc8de10f713f

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

Telemetry Enabled:
False

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\---\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1046364451.zip

Performance Trace Logs:
C:\Users\---\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

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

Enabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

shared HWDB_CITY_ZONE_VIEW = let
Источник = Oracle.Database("oradb11p09.group.s7/intranet.orcl", [HierarchicalNavigation=true]),
INTRA = Источник{[Schema="INTRA"]}[Data],
HWDB_CITY_ZONE_VIEW1 = INTRA{[Name="HWDB_CITY_ZONE_VIEW"]}[Data]
in
HWDB_CITY_ZONE_VIEW1;

 

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@afterlanding,

 

Try to clear permissions in data source settings.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks, but it didn't help me.

Helpful resources

Announcements
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.