Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
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.
@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
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
@deepan_94,
Do you use VPN in your scenario?
Regards,
Lydia
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?
@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
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
@deepan_94,
I would recommend you open a support ticket on the support.powerbi.com site.
Regards,
Lydia
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;
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |