Unexpected Error: Couldn't load the model schema using DirectQuery with Oracle data

[rohithkothaneth]

Hello,

Upon trying to connect to an Oracle database using DirectQuery, I encountered an Unexpected Error: Couldn't load the model schema. 

But when tried thesame source to import option, it is working without any issue.  Getting error for DirectQuery method.  Have provided the log below and would appreciate help on how to resolve the error. Many thanks in advance.

Feedback Type:
Frown (Error)

Timestamp:
2019-04-09T17:13:06.0959177Z

Local Time:
2019-04-09T13:13:06.0959177-04:00

Session ID:
51b6aac5-bd24-459e-8f3e-cb463c15691f

Release:
January 2019

Product Version:
2.65.5313.1562 (18.12) (x86)

Error Message:
Couldn't load the model schema.

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

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

Peak Virtual Memory:
1.44 GB

Private Memory:
392 MB

Peak Working Set:
422 MB

IE Version:
11.1029.16299.0

User ID:
bd0eace4-0c36-4f7a-bc20-40eae68d67a6

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

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\adcgnx5\AppData\Local\Microsoft\Power BI Desktop SSRS\FrownSnapShot1531878198.zip

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

Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
PBI_qnaLiveConnect

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI Report Server, Power BI

Formulas:

section Section1;

shared T_DATE_REFERENCE = let
Source = Oracle.Database("IP Address:Port_no/service_name.com", [HierarchicalNavigation=true]),
SYSTEM_ANALYTICS = Source{[Schema="SYSTEM_ANALYTICS"]}[Data],
T_DATE_REFERENCE1 = SYSTEM_ANALYTICS{[Name="T_DATE_REFERENCE"]}[Data]
in
T_DATE_REFERENCE1;

Thanks,

Rohith

[v-chuncz-msft]

@rohithkothaneth ,

You may check if the post below helps.

https://community.powerbi.com/t5/Desktop/Couldn-t-load-the-model-schema-Direct-Query/td-p/573637

[rohithkothaneth]

@v-chuncz-msft 

Thank you for youu response.  I'm having issue when I trying to get data from Oracle database using Direct Query.  But when I tried to see if SQL Server database source also has the same issue.  I'm actually able to get data for SQL server database using Direct query.  

Per the On-premises gateway requirement link below, for both Oracle and SQL Server database, it is mentioned as Gateway is required.  But im able to get the datafor SQL Server database but not for Oracle database.

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources#on-premises-gateway-requi...

So thinking is this issue has to do with something else.

Thanks,

Rohith