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 (Highlight to read) 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;
Feedback Type:Frown (Error)Timestamp:2018-09-07T03:36:42.1815466ZLocal Time:2018-09-07T10:36:42.1815466+07:00Session ID:abb9dd08-b254-4050-97ed-2bb6521f6c7bRelease:August 2018Product 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 GBPrivate Memory:588 MBPeak Working Set:719 MBIE Version:11.2430.14393.0User ID:fdf30d0c-a44f-43f8-b8bf-cc8de10f713fWorkbook Package Info:1* - ru-RU, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.Telemetry Enabled:FalseModel Default Mode:DirectQuerySnapshot Trace Logs:C:\Users\---\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1046364451.zipPerformance Trace Logs:C:\Users\---\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zipDisabled Preview Features:PBI_shapeMapVisualEnabledPBI_newFromWebPBI_SpanishLinguisticsEnabledCustomConnectorsPBI_variationUIChangePBI_canvasTooltipsPBI_PythonSupportEnabledPBI_showIncrementalRefreshPolicyPBI_compositeModelsPBI_DB2DQEnabled DirectQuery Options:PBI_DirectQuery_UnrestrictedDisabled DirectQuery Options:TreatHanaAsRelationalSourceCloud:GlobalCloudDPI Scale:100%Supported Services:Power BIFormulas: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]inHWDB_CITY_ZONE_VIEW1;