Appending data from external semantic model

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.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#working-with-a-composite-model-based-on-a-semantic-model

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.