Forum Discussion

cymorg's avatar
cymorg
Resolver I
5 years ago
Solved

Data Gateway update: Causes SQL Server error: An expression services limit has been reached

After updating my on-premesis data gateway one of my scheduled report refreshes is failing with a SQL Server error "An expression services limit has been reached".  That error typically indicates a S...
Dataflow
Need Help
  • cymorg's avatar
    cymorg
    5 years ago

    I had about 40 transformations applied to the data in PowerBI Desktop, mostly Replace() methods.  Reduce this to under 32 eliminates the problem.  So, whatever way Microsoft send the DAX to SQL Server seems to have changed between gateway versions.  I ended up moving all my Replace() methods out of PowerBI and into SQL Server and the problem is resolved. 

  • cymorg's avatar
    cymorg
    Resolver I
    5 years ago

    This error only started to happen after installing the latest version, 3000.63.6 (October 2020 (Release 2)).  It's disappointing that an "upgrade" would cause such a problem, it means I may have to revert to using temporary tables which is more work with no additional value.

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi cymorg ,

       

      If so,I would  suggest you create a support ticket via below link and out relevant personnel will help to handle it.

       https://powerbi.microsoft.com/en-us/support/

       

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!