Power BI Dataset Merge

Swap__nil____ — Mon, 27 Nov 2023 15:53:20 GMT

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

Re: Power BI Dataset Merge

Anonymous — Wed, 29 Nov 2023 06:37:18 GMT

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

Re: Power BI Dataset Merge

Swap__nil____ — Wed, 29 Nov 2023 15:04:40 GMT

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

topic Re: Power BI Dataset Merge in Developer

Power BI Dataset Merge

Re: Power BI Dataset Merge

Re: Power BI Dataset Merge