Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.