Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Can I append two Power BI Datasets in PBI Desktop?
If not,Any alternative solution for the same?
Thanks.
But we are looking to merge two powerbi dataset(Two Semantic Models) not the Two datasource
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