OFFSET Optimization for Large Dataset

I think I have narrowed down the issue to deployment in Analysis Services.  The measure is working as expected with a subset of the data in PowerBI with an import connection to a SQL database.  I've loaded the same subset of data to Analysis Services with the same OFFSET measure used in PowerBI, but when Analysis Services is connected to PowerBI it returns an error that there isn't enough memory to view the output of the measure.  I have attempted scaling up AS with no difference in outcome.  Is the OFFSET measure not available for use in Analysis Services yet?  Is there some other difference that could be causing the issue?  Thank you for any help!