i need to create a text box to make search in two different database

[haithambat]

i have two different database with the same feldes
i have created a separate visual for each
i want to create a text box to make search in both together at once

[Anonymous · Accepted solution]

Hi @haithambat

To search two different databases with the same fields in Power BI, you can use the Append function in Power Query.

This feature allows you to concatenate queries from multiple sources to merge data into a single table.

Load both databases into Power BI.

Use the Append Query option in Power Query to combine these queries into one.

After appending, you can rename, organize, and prepare new tables for reporting.

You can view the link below for more details:

How to Append Data in Power BI - Zebra BI

Regards, 

Nono Chen 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[haithambat]

thank you very much 😍