Couldn't load the model schema Direct Query

[Anonymous]

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

[v-chuncz-msft]

@Anonymous,

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

[Anonymous]

@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]

@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? 

[Anonymous]

@Nickgastaldi

Yup, thats what I did.

I tried to install on premise gateway but it gave me error while installation, I am thinking -- I might have to get the antivirus disabled while installation, this will take some time, so I went ahead with personal gateway. I can setup schedules with it but the main issue remains same.

Thanks

[Nickgastaldi]

@Anonymous

for what i know, Personal Gateway is only for Import and Scheduled import, it does not support Direct Query properly

as stated in MS Doc 

• On-premises data gateway: Multiple users can share and reuse a gateway in this mode. This gateway can be used by Power BI, PowerApps, Flow or Logic Apps. For Power BI, this includes support for both schedule refresh and DirectQuery
• Personal: This is for Power BI only and can be used as an individual without any administrator configuration. This can only be used for on-demand refresh and schedule refresh. This selection launchs installation of the personal gateway.

hope this helps you solve your issue 🙂 

[Anonymous]

@Nickgastaldi

I will try to install and configure it and confirm back here.

Thanks!!

[rohithkothaneth]

@Anonymous 

Did it worked for you?