Direct Query is not working while Connecting to Oracle database

[deepan_94]

Not able to connect to the Oracle DB using Direct Query Mode

Feedback Type:
Frown (Error)

Timestamp:
2017-12-19T10:52:51.0660494Z

Local Time:
2017-12-19T16:22:51.0660494+05:30

Session ID:
ff5cebf2-e6bf-4c74-a7dd-a468bb9100c9

Release:
October, 2017

Product Version:
2.51.4885.1423 (PBIDesktop) (x64)

Error Message:
Couldn't load the model schema.

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.6.1 or later [Release Number = 394271]

Peak Virtual Memory:
3.64 GB

Private Memory:
272 MB

Peak Working Set:
370 MB

IE Version:
11.0.9600.18837

User ID:
2795a532-5a7b-46f4-83d2-985af37ff228

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

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

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

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

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_daxTemplatesEnabled
CustomConnectors
PBI_reportBookmarks

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Couldn't load the schema for the database model:
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

Activity ID:
null

Time:
Tue Dec 19 2017 16:22:37 GMT+0530 (India Standard Time)

DPI Scale:
100%

Supported Services:
Power BI Report Server, Power BI

[v-yuezhe-msft]

@deepan_94,

Based on your error message, you are using Power BI Desktop for Power BI report server to connect to Oracle. I test the scenario as yours, everything works well. 

Could you please verify that if you can connect to Oracle from Oracle SQL developer? Please make sure that SQL developer is installed on  the same machine with Power BI Desktop.

Regards,
Lydia

[deepan_94]

@v-yuezhe-msft

I can able to connect to the Oracle. Both the applications were installed on the same machine.

Also, I'm not able to connect power BI Desktop to Oracle.

It's showing the same error message.

[v-yuezhe-msft]

@deepan_94,

Does the error occur when you use import mode? And how about you connect to other data sources in Power BI Desktop?

Regards,

Lydia

[deepan_94]

@v-yuezhe-msft

In import mode it was working fine.

When I Tried with SQL Server it was working.

But in Oracle I'm getting the error.

Regards,

Deepan

[v-yuezhe-msft]

@deepan_94,

Do you use VPN in your scenario?

Regards,

Lydia

[deepan_94]

@v-yuezhe-msft

I think so Yes, Because I'm connecting it in my VM!!!

If Yes, What can i do?

If No??? Can you tell me why VPN is needed for this purpose?

[v-yuezhe-msft]

@deepan_94,

Based on my search, the above error could occur when connecting to database through company VPN, then please verify if you use VPN in your scenario.

There is a similar thread for your reference.
http://community.powerbi.com/t5/Issues/Couldn-t-load-the-model-schema-message-when-connected-to-comp...

Regards,
Lydia

[deepan_94]

@v-yuezhe-msft

I have discussed with my colleagues .... We are not using VPN.... Since we are working on the client place.... We are directly connecting the Database.....

Regards,

Deepan

[v-yuezhe-msft]

@deepan_94,

I would recommend you open a support ticket on the support.powerbi.com site.


Regards,
Lydia

[deepan_94]

Getting this error while connecting to Oracle DB in Direct Query Mode

Feedback Type:
Frown (Error)

Timestamp:
2017-12-19T11:47:58.6619634Z

Local Time:
2017-12-19T17:17:58.6619634+05:30

Session ID:
ff5cebf2-e6bf-4c74-a7dd-a468bb9100c9

Release:
October, 2017

Product Version:
2.51.4885.1423 (PBIDesktop) (x64)

Error Message:
Couldn't load the model schema.

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.6.1 or later [Release Number = 394271]

Peak Virtual Memory:
3.64 GB

Private Memory:
272 MB

Peak Working Set:
370 MB

IE Version:
11.0.9600.18837

User ID:
2795a532-5a7b-46f4-83d2-985af37ff228

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

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

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

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

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_daxTemplatesEnabled
CustomConnectors
PBI_reportBookmarks

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Couldn't load the schema for the database model:
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

Activity ID:
null

Time:
Tue Dec 19 2017 16:22:37 GMT+0530 (India Standard Time)

DPI Scale:
100%

Supported Services:
Power BI Report Server, Power BI

Formulas:

in
Source;