Forum Discussion

NoDice's avatar
NoDice
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Semantic Model: Error on refresh and not gracefully

Setup We use dbt to run SQL transformation files that load data into a fabric data warehouse.  We use fabric pipelines to call dbt to run those scripts and when they finish it triggers the semantic...
  • NoDice's avatar
    1 year ago

    Update on this. We have implemented a solution that is working for anyone else struggling with this.

     

    With the help of some very talented engineers, we impletmented a custom dbt materialization method that no longer drops and creates tables on refresh. Ever since that change, we haven't had any errors with the semantic model refresh. 

     

    This adds to the suspision that fabric has some bugs with how it handles the parque file relationships. 

     

    I'll mark this as the solution. Happy coding everyone.