Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
thank you very much 😍
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |