Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dduffy
Regular Visitor

Create Report based on Data Gateway

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. 

 

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

great thanks I was hoping that I could just use the powerbi service rather than have to use the desktop version, because I am a mac user, so i have to run VMs to get the desktop version to work. So if the gateway worked direct from the powerbi service that would have been great. but i will give the desktop version a go
eskyline
Resolver I
Resolver I

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors