Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I need to append data from 2 sources:
The option to append tables is only available in the PowerQuery editor. But the data coming from the conection to external semantic model is not visible there.
How can I append these two?
View in the main PowerBI window:
View in the "Transform Data" editor (data from external semantic model not visible):
Append wizard view (data from external semantic model not available):
Solved! Go to Solution.
Hi,
Thanks for the solution @lbendlin provided, and i want to offer some more information for user to refer to.
hello @plew , the power bi dataset model cannot be edited in Power Query,you can't change data types of columns that are loaded from a Power BI semantic model or Analysis Services source. If you need to change the data type, either change it in the source or use a calculated column. You can refer to the following link about the limtations.
if you want to transform the data, it is better that download the pbix file, then get the data from the downloaded file, then import the data to the current power query, you can refer to the following link about it.
Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This article also states explicitely:
The following Live Connect (multidimensional) sources can't be used with composite models:
- SAP HANA
- SAP Business Warehouse
- SQL Server Analysis Services
- Power BI semantic models
- Azure Analysis Services
When you connect to these multidimensional sources by using DirectQuery, you can't connect to another DirectQuery source or combine it with imported data.
This article also states explicitely:
The following Live Connect (multidimensional) sources can't be used with composite models:
- SAP HANA
- SAP Business Warehouse
- SQL Server Analysis Services
- Power BI semantic models
- Azure Analysis Services
When you connect to these multidimensional sources by using DirectQuery, you can't connect to another DirectQuery source or combine it with imported data.
Hi,
Thanks for the solution @lbendlin provided, and i want to offer some more information for user to refer to.
hello @plew , the power bi dataset model cannot be edited in Power Query,you can't change data types of columns that are loaded from a Power BI semantic model or Analysis Services source. If you need to change the data type, either change it in the source or use a calculated column. You can refer to the following link about the limtations.
if you want to transform the data, it is better that download the pbix file, then get the data from the downloaded file, then import the data to the current power query, you can refer to the following link about it.
Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In DAX you can use UNION instead but that won't work with live connection sources.
What is the business problem you are trying to solve?
I need to summarize and analzye spend data, that is coming from two sources:
Both data files have different structure and there can be some duplicates between them. I have ideas how to clean them up in PowerQuery. But I'm stuck on the first step - getting the data together in one table to compare, wrangle and then analyze.
It's not optimal but you can import the data from that semantic model by using the Analysis Services connector.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
13 | |
12 | |
11 | |
8 |
User | Count |
---|---|
43 | |
26 | |
16 | |
15 | |
12 |