Forum Discussion

usrivastava's avatar
usrivastava
Frequent Visitor
2 years ago

Incremental Refresh Error

Hi Team,

 

We have set up Incremental refresh in desktop as archived data for 5 years and incremental refresh for 2 months in a fact tables, we are getting the below error. The data to be uploaded is quite big in size. We are able to load the last 7-8 months of data but anything more than that is giving us the below error - 

 

 

Thanks in advance for any help here.

Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    2 years ago

    Hey usrivastava ,

     

    can you please share the following:

    • is your semantic model residing in a workspace that is backed by Premium, Fabric, or Premium Per User Capacity? If yes, what capacity?
    • What is is the size of the semantic model after you loaded 7-8 months?
    • How long does the initial load take, after you configured the incremental refresh and published the report to the service..

    Regards,

    Tom

    • usrivastava's avatar
      usrivastava
      Frequent Visitor
      2 years ago

      Hi Tom,

       

      PFB my response - 

      • is your semantic model residing in a workspace that is backed by Premium, Fabric, or Premium Per User Capacity? If yes, what capacity? -- Fabric Premium
      • What is is the size of the semantic model after you loaded 7-8 months? Approx 7 GB
      • How long does the initial load take, after you configured the incremental refresh and published the report to the service.. --> Around 3 hours