How to bring two different table in One query

[Amjad1002]

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 into power BI?

Thanks

[Amjad1002]

Hi,

Both tables are coming diffrent schema and both have diffrent data with diffrenet header. One is Date calender table which I am currently, using as a Vlookup table to match Orgnization calander. And second one have data with date entries. 

[hummingbird]

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.

[Anonymous]

What you can do is first to bring both the queries in Power BI and then go to Power Query.
Assumption: As per your use case and my understanding, what I got is that both the queries might be having same schema structure but different data. 

Goto Power Query.
Merge both queries, i.e., Select table 1 and table 2 and click on Merge queries. 
> Now while merging the queries, you can merge on the existinig table or you have an option to create a new Table from scratch where the data of those 2 tables will appended in a single table. 


Thank you. 
If my answer helps you, please mark it as solution.