Composite model connected to AAS is not getting refreshed properly. Why?

[Sreya]

I have a composite model dataset connected to AAS and Azure Data Lake. When I am trying to refresh the composite model dataset then Old object names are not getting refreshed. Suppose in AAS a meassure name is 'NetRev' and few days later it changed to 'NetRevenue' then after refreshing Composite model it is keeping old name i.e 'NetRev'.

Can anyone please help here?

[v-janeyg-msft]

Hi, @Sreya 

I think I need to know more information to help you.

You need to test:

• If there is only one data source AAS, 'NetRev' will become'NetRevenue'? Can it be refreshed normally by turning LC into DQ? Whether the measure was created before connect to PBI?
• Do you have mixed query in two data sources? There may be complex queries that cause refresh failures.

Use composite models in Power BI Desktop - Power BI | Microsoft Docs

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Sreya , check if you have access to the power query to change the name in the source.

In power query, right on table , advance editor and change details 

[Sreya]

@amitchandak I have access to power query but it shows nothing. The composite model dataset is connected to AAS and Azure Data Lake, now the storage mode is Direct Query.

[amitchandak]

@Sreya , refer to this video if this or a second one can help

https://www.youtube.com/watch?v=59PUFuuCrbY

https://www.youtube.com/watch?v=meUxcbwujl8

[Sreya]

@amitchandak This is not the case. While dataset is not a composite model then the dataset is getting refreshed but while the dataset is connecting to one more data source Azure Data Lake then the dataset is not getting refreshed properly.

Note- While dataset is connecting to only AAS then the storage mode is Live Connection, but when it conncets to one more data source the storage mode changes to Direct Query.