Semantic Model time out

[RoSch]

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!

[RoSch · Accepted solution]

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

[Anonymous]

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

[aj1973]

Hi @RoSch 

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

[RoSch]

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]

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