Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Loadfailure in services

  Hi all   We got a loadfailure for a semantic model in the Service. Error mes below. Load works in dev and test. datasources in test and prd are identical but load fails in prd. It´s just one v...
Need Help
  • v-prasare's avatar
    v-prasare
    1 year ago

     

    Anonymous, Thanks for reaching MS fabric community support.

     

    • If the query is slow this could be due to more data in prod or you need to optimize the view, Different indexing or execution plans
    • check Resource contention (other workloads affecting performance), If the view times out, this could be the root cause.
    • Can you try below and let me if this works for you?
      Open Tabular Editor 2 and load the .BIM file, Expand Data Sources → Click on the data source used in the failing query. In the Properties pane, locate Command Timeout and Increase the value to optimal value. Save and deploy the model and Try refreshing the semantic model in PRD again.

     

     

     

     

    Thanks,

    Prashanth Are

    MS fabric community support

     

     

     

v-prasare's avatar
v-prasare
Icon for Community Support rankCommunity Support
1 year ago

 

Anonymous, Thanks for reaching MS fabric community support.

 

  • If the query is slow this could be due to more data in prod or you need to optimize the view, Different indexing or execution plans
  • check Resource contention (other workloads affecting performance), If the view times out, this could be the root cause.
  • Can you try below and let me if this works for you?
    Open Tabular Editor 2 and load the .BIM file, Expand Data Sources → Click on the data source used in the failing query. In the Properties pane, locate Command Timeout and Increase the value to optimal value. Save and deploy the model and Try refreshing the semantic model in PRD again.

 

 

 

 

Thanks,

Prashanth Are

MS fabric community support