Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have 4 databases, with the same structure (fields, etc) but distinct data:
(2 databases in the image).
How i unify this data in the same report ( for example sum data of any field)?
In the Page of reporte i only show the data of database 1 (source 1).
Any idea?.
Solved! Go to Solution.
Merge the tables into one in Power Query
Thank's. But , how i do it?
In the Query Editor, go to Home tab > Merge Queries
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |