Want to implement a combination chart with help of two different data base from the sql server

[umeshjss]

Hi Team,

I've two tables t1 and t2 and these t1 and t2 are loacted in different data base in db1 and db2 respectively . So How I'll create  a combination chart with theses two tables(t1 and t2) as a combined result set?

Thanks,

Umesh

[Phil_Seamark · Accepted solution]

Hi @umeshjss

How similar are the tables in structure?  You could consider combining the two tables into 1 table using the query editor.

[v-sihou-msft · Accepted solution]

@umeshjss

If you want to show data from two tables as two different categories, you can build relationship between two tables, or use Merge Queries in Query Editor to combine the data from different into same dataset.

If your two tables are same structure and you want to combine the data on row level, you can use Append Queries in Query Editor.

Reference:
Shape and combine data in Power BI Desktop

Regards,

[Phil_Seamark · Accepted solution]

Hi @umeshjss

How similar are the tables in structure?  You could consider combining the two tables into 1 table using the query editor.