Forum Discussion

Amjad1002's avatar
Amjad1002
Helper III
3 years ago

How to bring two different table in One query

Hello Folks, I am trying to bring two diffrent table from my oracle data base. I have two query and two diffrent tables but I am thiking is it possible to bring both table through one direct query i...
Need Help
hummingbird's avatar
hummingbird
Helper II
3 years ago

Hi,

 

Yes, it is possible to bring two different tables from your Oracle database into Power BI using a single DirectQuery.

To do this, you can create a SQL query that joins the two tables together and then use this query as the basis for your DirectQuery connection in Power BI. Here are the general steps:

  1. Write a SQL query that joins the two tables together. The query should include all the fields you want to bring into Power BI.

  2. In Power BI Desktop, select "Get Data" and choose "Oracle database" as the data source.

  3. In the "Oracle database" dialog, select "DirectQuery" as the connectivity mode.

  4. In the "Navigator" window, select "Advanced options" and enter your SQL query in the "SQL statement" field.

  5. Click "OK" to create the connection.

  6. Once the connection is established, you will see a single table in the Fields pane of Power BI Desktop that includes all the fields from your SQL query.

  7. You can then use this table to create visualizations and reports in Power BI.

Note that in order for this to work, both tables must be in the same database schema and you must have permissions to query both tables. Additionally, performance may be affected if the joined table is very large, so you may want to consider using other techniques like data modeling or filtering to optimize your query.