Forum Discussion

sqlguru448's avatar
sqlguru448
Helper 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. 

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

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super 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
      Helper 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.