Power BI Dataset Merge

[Swap__nil____]

Can I append two Power BI Datasets in PBI Desktop?
If not,Any alternative solution for the same?

[Swap__nil____]

Thanks.
But we are looking to merge two powerbi dataset(Two Semantic Models) not the Two datasource

[v-yiruan-msft]

Hi @Swap__nil____ ,

Thanks for reaching out to us with your problem. If you're talking about merging two queries into one, you can refer the following links to get it by using the append function inside Power Query Editor.

How to Combine Datasets in Power BI - Zebra BI

Append queries - Power Query | Microsoft Learn

If you are merging two datasets, you can refer to the following link to do it.

powerbi - How to combine multiple datasets into a new dataset? - Stack Overflow

The ability to query across multiple Datasets is currently in preview.

Using DirectQuery for Power BI datasets and Analysis Services

Or you can build a third dataset that imports some of the same source data as the other two.

---

Best Regards