Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Sreya
Helper II
Helper II

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

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?

5 REPLIES 5
v-janeyg-msft
Community Support
Community Support

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
Super User
Super User

@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 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

@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.

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

@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.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.