Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
Solved! Go to 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!
Hi @GLIDO,
When connecting to any relational database you can mention Native Query in Advanced options. See example below:
dq\
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
79 | |
58 | |
35 | |
34 |
User | Count |
---|---|
99 | |
59 | |
56 | |
46 | |
40 |