merge two tables/queries

[Anonymous]

I have 3 queries in the model..Empl,License and Oracle.

• Empl joined to Oracle like Empl.username and Oracle.loginID
• License joined to Empl with Empl.username and License.userID.Here ,License.userID is a custom column in the powerBI calculated as LEFT(License[Email],(FIND("@",License[Email],1)-1))

The report below gives me both Oracle and Licenses as a separate columns as shown in the image.I want to have 'Oracle' listed as another row in  the report similar to licenses(enterprisepack,power_bi_pro etc).The requirement is to have both Oracle and License data in single table.

I dont know to how to acheive this,especially when the model in my report doesnt join Oracle and License tables.

[stretcharm · Accepted solution]

If the Queries are a similar structure you can Append in Query Editor on the Home Tab.

If they are not the same adjust them in the query editor first. Make the columns the same name and types the same.

If you don't have a licence type for the oracle ones. Add a Custom Column with a value of "Oracle"