Forum Discussion
Connect data from different datasets
Hi, I have several datasets that I need to connect together to visualize and filter in the same figure. The datasets look similar to this: DATASET 1 Organization Exposure hours ...(oth...
Hi Anonymous ,
What's your desired result? Whether below table is what you want? Do DATASET1 and DATASET2 have the same table structure? If yes, you can combine these two "dataset" into one query using Append Queries in Power Query Editor.
| Organization | Exposure hours | ...(other olumns) |
| A | 100 | ... |
| B | 140 | ... |
| C | 130 | ... |
| D | 160 | ... |
| E | 240 | ... |
Merge Vs. Append In Power BI In Power Query Editor
Best Regards