Forum Discussion

RKM's avatar
RKM
Icon for Helper IV rankHelper IV
4 years ago

Error - Table With Calculated Column Can't have an Incremental Refresh Policy in Hybrid Mode

I'm trying to explore HyBrid option for real time data.

My SQL View Contains a Last_Updated (Datetime) column on which I'm trying to build this incremental load

In PBI on this table, I do have a few Calculated columns and Measures.

 

Getting error as below screenshot. Could someone please highlight what is the possible cause (and/or) / workaround?

 

 

 

Need Help
Tips and Tricks

3 Replies

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion
    4 years ago

    RKM 

    Contextually this thread may help you ! May be due to calculated columns ! Check this and let me know if it helps!

    • RKM's avatar
      RKM
      Icon for Helper IV rankHelper IV
      4 years ago

      Did you by any chance missed sharing any link? Which Thread you referred please?

      Meanwhile it seems I got the root cause,

      The Last Updated Column I referred in the view is actually a calculated column as 

       

      LAST_UPDATED = SELECT MAX(VALUE) FROM (VALUES (TBL.APPROVED_AT), (TBL.PROCESSED_AT)) AllTimeStamps(VALUE))

       

      (I.E. I'm picking max datetime of 2 columns and intention was that either of the 2 column altered then this LAST_UPDATED will be updated and I'll be able to fetch it in my PBI)

      ~ Now seeing that is not allowed, I'm clueless how to really manage my scenario.

       

      [Something really good came from MS Power BI I thought, but with these restrictions, it is really making life difficult. May be just for me.]