Forum Discussion

RoSch's avatar
RoSch
Frequent Visitor
2 years ago
Solved

Semantic Model time out

Hi everyone,

 

I know there are already many posts on this topic, but there is no solution.

 

I have published on my tenant a semantic model to which are connected various reports (in shared and private workspaces) and potentially excel workbooks as the user have the build privilege. The source of the model is azure databricks.

 

Since yesterday evening at 19:00 CET the model started going in time out after 4 x refresh attempts of 2h each, which has never done before. It usually takes 15 minutes and it worked just fine 2 hours prior, during which no change has been made:

 And it gave the following error:

Spoiler
Timeout expired. The timeout period elapsed prior to completion of the operation.. The exception was raised by the IDbCommand interface. Table: 

 

I tried all of the following:

  • Pubblishing same model in other workspace: it refreshes fine
  • Pubblishing same model with different name: it refreshes fine
  • Refreshing other models with the same data source: they refresh fine
  • Clearing the cache and republishing & overwriting the model: same timeout problem

 

I really am at a loss here at what could have happened.

It is as though there is something running on the model that prevents it from refreshing, even though the user base has been the same for over 6 months and I don't think there has been a different usage of the model.

 

Any help would be appreciated!

 

Many thanks!

  • Hi everyone,

     

    seems like it was a bug on MS side. I opened a ticket straight away on Friday morning and was solved during the weekend. It was something out of my control apparently.

     

    Thanks for trying to help.

     

    Best,


    Rocco

5 Replies

  • RoSch's avatar
    RoSch
    Frequent Visitor

    Hi everyone,

     

    seems like it was a bug on MS side. I opened a ticket straight away on Friday morning and was solved during the weekend. It was something out of my control apparently.

     

    Thanks for trying to help.

     

    Best,


    Rocco

  • aj1973's avatar
    aj1973
    Community Champion

    Hi RoSch 

    How about you change the name of the model and republish it in the same workspace ! does the refresh work fine?

    • RoSch's avatar
      RoSch
      Frequent Visitor

      Hi aj1973 ,

      yes, it works fine if I publish it under a different name. The problem is that there are many personal reports and excel pivots attached to the model, so I cannot really go that route.

      Best,


      R

      • aj1973's avatar
        aj1973
        Community Champion

        Well I don't think you would have too many choices as the original dataset seems bugging.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, RoSch 

    Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

    Best Regards

    Yongkang Hua