Issue with Composite model in Power BI

[sqlguru448]

Hello Folks,

I have created a report using composite model with 2 different data sources, one coming out of Azure Analysis services with Live connection and other with SQL server as direct query. 

I have in built measures within Power BI report and the report works fine perfectly, but if I change the envoriment of these sources from DEV to PRODUCTION then all the measures which are built within Power BI report have disappeared. Is this expected? or is this a bug in the new feauture? 

Is there a simple workaround to fix it instead of re-writing all the measures again?

Thank you

[sqlguru448]

Any inputs?

[amitchandak]

@sqlguru448 , You have done using edit connections? or you have done change in power query, or you have created power query parameter and changing using that?

First, change back to dev and check do you get all measures back.

Try to use this method from guyinacube for connections change -https://www.youtube.com/watch?v=XIq5vN5oPf8

[sqlguru448]

I am trying to change it via "Data source settings", the issue is in Azure Analysis Service connection. Whenever I change it from Dev to Production the measures disappear.

If I change back from Production to Dev, the measures are still lost.