Direct Query against Oracle: Getting error 'Could not load model' in Power BI Service

[Eric7]

I have a dataset with one simple query using Direct Query to refresh from an Oracle database through  an On-Prem Gateway. In Import mode this works fine, but in Direct Query mode, I get this error when opening the report in Power BI Service:

I have set up the Gateway connection for the Dataset in the Settings in Power BI Service.

Should Direct Query work with the same the on-prem gateway setup like it does in Import mode?

Erik

[v-cgao-msft]

Hi @Eric7 ,

1. What mode of gateway are you using? If you are using a personal mode gateway, please change to a standard mode gateway, if the gateway is not the latest version, please update the gateway to the latest version.

2. Related topics and solutions.

Solved: Oracle | Gateway | Direct Query | Report couldn't ...

Solved: Retrieving Data Problem With Direct Query From Ora...

and new version of desktop download link.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Shahfaisal]

See if this helps - https://community.powerbi.com/t5/Service/Direct-Query-Couldn-t-load-the-model-schema-associated-with...