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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.