Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Deployment Pipelines - Change datasource - Cannot load model

Hello Community,

 

I am testing deployment pipelines at a customers premium capacity. I have create a test workspace and a productive workspace. Via data source rules I´d like to change the source when deploying from test to prd. The source is an Azure Analysis Service model. When I set up the rules I chose "Other" and added the information for the dataset. But after the deployment I get the following error when opening the report:

 

"Cannot load model

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again"

 

I have acces to the source and the report with this source in the real productive environment is working fine. When I am checking the datasource in the report in the service, deployed by the pipeline, the new and correct datasource was added to the dataset. When I am downloading the file I can´t open the report because the connection to the AAS model isn´t corret. As Server "server" and as Database "database" is used. In some way the data source isn´t changed correctly.

 

Best,

Mogry

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I found the issue I had with the deployment pipelines and rule for changing the data source. Our modelnames were not the same...One model was named "Modell" and in the other environment "Model". This can´t be changed by the pipelines and needs do be named in both stages identical. 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I found the issue I had with the deployment pipelines and rule for changing the data source. Our modelnames were not the same...One model was named "Modell" and in the other environment "Model". This can´t be changed by the pipelines and needs do be named in both stages identical. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have openend a support ticket and had a session with a MS PBI supporter. Unfortunately this not helped and they will discuss it internally. I will post the outcome here later.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous 

      It is generous of you to share your workaround in this post.  More people will benefit from it.

       

      Best Regards,

      Rico Zhou

  • Karola's avatar
    Karola
    Advocate I
    4 years ago

    I have the same problem and microsoft is looking into it since beginning of december already. 

    we also connect to analysis server. 
    we have for instance environment T server and database t-model. then we deploy to environment A server and a-model. 

    this always worked correctly up until end of november where i now also get the error of cannot load data. So that the names of the models should be the same is not correct because it has worked normally before..