Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have my data gateway set up and successful connects to the Oracle database.
I am in PowerBI web version, how do I create a report using the direct query option ?
I thought once I had the data gateway up and running and a data source added I would be able to create dataasets from the data source.
Solved! Go to Solution.
Hi @dduffy,
Agree with eskyline. In Power BI Desktop, you have the "DirectQuery" option to connect to Oracle database, for more details, please review the following article.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-oracle-database/
Thanks,
Lydia Zhang
Hi @dduffy,
Agree with eskyline. In Power BI Desktop, you have the "DirectQuery" option to connect to Oracle database, for more details, please review the following article.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-oracle-database/
Thanks,
Lydia Zhang
Hey dduffy,
I'm pretty sure the only options for connecting to on-prem data when in the Power BI Service/web version is the Microsoft Analysis Services (SSAS) cube option. If you did (and you don't since you are using Oracle) have some SSAS connections defined in the gateway they would appear if you chose that option in Get Data. When working with SSAS cubes most often you use the Direct Query model so in that case it doesn't really make sense to do imports.
I'm guessing some day they add the feature of connecting to relational databases with connections defined in the gateway to the Power BI Service/web but for now your only real option is to create the report in the Power BI Desktop the publish it to the Power BI Service. If the server name and database names match it should like up when you publish and connect to your gateway connection. You can always check that under the Dataset ... option in the Power BI Service once your report is published. My experience is all with SQL Server databases but I'd guess the Oracle databases and connections would act the same.
Good luck.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.