Hello. If I try to direct query to a Oracle DB, I always get this error. Does anyone have any idea how to fix?
Here's the details:
Feedback Type: Frown (Error) Timestamp: 2018-07-22T10:13:25.2673698Z Local Time: 2018-07-22T11:13:25.2673698+01:00 Session ID: e4ba6158-e726-4616-a44d-c4abfcdaac41 Release: February 2018 Product Version: 2.55.5010.641 (PBIDesktop) (x64) Error Message: Couldn't load the model schema. OS Version: Microsoft Windows NT 10.0.14393.0 (x64 en-US) CLR Version: 4.7 or later [Release Number = 460805] Peak Virtual Memory: 34.1 GB Private Memory: 439 MB Peak Working Set: 552 MB IE Version: 11.2189.14393.0 User ID: bab14742-a5d4-4cff-8247-99227d97fbf6 Workbook Package Info: 1* - pt-PT, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: DirectQuery Snapshot Trace Logs: C:\Users\jpsantos\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1218832165.zip Performance Trace Logs: C:\Users\jpsantos\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_EnableReportTheme PBI_numericSlicerEnabled PBI_SpanishLinguisticsEnabled CustomConnectors PBI_reportBookmarks PBI_AdobeAnalytics PBI_qnaExplore PBI_variationUIChange PBI_customVisualsGallery PBI_HanaV2 Enabled 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: Sun Jul 22 2018 11:10:31 GMT+0100 (GMT Daylight Time) DPI Scale: 100% Supported Services: Power BI Formulas: section Section1; shared Query2 = let Source = Oracle.Database("---"]) in Source;
Please answer on below questions:
1. Are you able to connect to Oracle DB via any database management tool like Database browser, SQL Developer etc.?
2. How much memory (RAM) are consuming by your report during refresh. Check it via Windows Resource Monitor. See details - https://www.digitalcitizen.life/how-use-resource-monitor-windows-7
3. Which version of Oracle DB you have? There are 12 and above which are under support for Direct Query - https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources
4. Provide screenshots on how you receive an error.
Did I answer your question? Mark my post as a solution!