Forum Discussion

sqlguru448's avatar
sqlguru448
Icon for Helper III rankHelper III
5 years ago

Issue with Composite model in Power BI

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.  ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
sqlguru448
Icon for Helper III rankHelper III
5 years ago

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.