Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Couldn't load the model schema Direct Query

Hi,

 

I am encountering issue : "Couldn't load the model schema" when trying to use Direct Query.

 

Database is Oracle 12.9

Power BI version: 2.64.5285.741 64-bit (November, 2018)

 

To establish connection wth database I have used this format:

Source = Oracle.Database("(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.COM)(PORT=XXXX))(CONNECT_DATA=(SERVICE_NAME=XXXXXXX)))",

 

This issue is only for direct query and am able to work with import options. We need to have direct query as our table has million and millions of rows and importing data is making the report refresh process very slow.

 

I have read most of the similar posted issue on community but it doesnot work for me. Kindly, help

 

Thanks in advance

Need Help

7 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    Anonymous,

     

    It seems that you might need to install and configure an On-premises data gateway.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-chuncz-msft,

       

      I successfullly installled and configured personal On-premise data gateway but it does not resolve my issue.

       

      Please let me know if am missing anything.

       

      Below is the error details:

       

      Feedback Type:
      Frown (Error)

      Timestamp:
      2018-11-28T15:59:33.5281161Z

      Local Time:
      2018-11-28T21:29:33.5281161+05:30

      Session ID:
      35264ac8-3e39-4bc3-8d08-9ee072b85ace

      Release:
      November, 2018

      Product Version:
      2.64.5285.741 (18.11) (x64)

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

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

      Peak Virtual Memory:
      3.87 GB

      Private Memory:
      346 MB

      Peak Working Set:
      469 MB

      IE Version:
      11.0.9600.19180

      User ID:
      fdf6e387-559c-4c83-815a-7b8c115fffcb

      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\myid\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot225424460.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

      Enabled DirectQuery Options:
      PBI_DirectQuery_Unrestricted

      Disabled DirectQuery Options:
      TreatHanaAsRelationalSource

      Cloud:
      GlobalCloud

      DPI Scale:
      100%

      Supported Services:
      Power BI

       

       

      Thanks in advance!

      • Nickgastaldi's avatar
        Nickgastaldi
        Resolver I
        7 years ago

        Anonymous

         

        i have 0 experience with PBI-Oracle but for what i know, you need to have a data gateway implemented on the server machine, not personal (local) gateway,  is it what you did?