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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
GLIDO
Helper I
Helper I

Writing own sql queries

Hi there,

 

I am stuck with an issue.  I've imported 10 tables using PBI Desktop from oracle, and created the joins as well. Things were fine till here. Now I've to add a coulumn to the master table (e.g. Table_1), Now this new column is based on some complex queries and sub querie. I was thing to use the oracle queries directly to populate the new column. 

 

Will that be possible in Power BI, coz back in SAP BO, we were able to write sql in IDT. I am new to powerBI.  

1 ACCEPTED SOLUTION

Hi @GLIDO,

 

You are able to put Native Query to a connection as I show on the screenshot even when importing data.

Please try.

 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

View solution in original post

3 REPLIES 3
zoloturu
Memorable Member
Memorable Member

Hi @GLIDO,

 

When connecting to any relational database you can mention Native Query in Advanced options. See example below:

 

dqdq\

Regards,

Ruslan

Hi Zolo,

 

The thing is I've to import the tables and cannot use the direct query option. 

Hence, I was trying the approach of first fetching the whole set of data and then filtering the data as per the needs, by using the sql queries. 

 

Thanks 

Hi @GLIDO,

 

You are able to put Native Query to a connection as I show on the screenshot even when importing data.

Please try.

 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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