Forum Discussion
Power BI Dataset Merge
Can I append two Power BI Datasets in PBI Desktop?
If not,Any alternative solution for the same?
2 Replies
- Swap__nil____Frequent Visitor
Thanks.
But we are looking to merge two powerbi dataset(Two Semantic Models) not the Two datasource - AnonymousNot applicable
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