Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

OFFSET() Measure compatible with a SSAS Live Connection (Dec 2023 PBI Desktop)

Title says it all, cannot get OFFSET to work with my Live Connection to SSAS with the Dec 2023 version of PBI. Thanks, Aaron
Need Help
  • TomMartens's avatar
    TomMartens
    2 years ago

    Hey Anonymous ,

     

    I'm sure the DAX Windowing functions like OFFSET are only supported with SQL Server Analysis Services Tabular 2022.

    If "Live Connection" means a prior on-premises version of SSAS Tabular, than it will not work.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
2 years ago

Hey Anonymous ,

 

I'm sure the DAX Windowing functions like OFFSET are only supported with SQL Server Analysis Services Tabular 2022.

If "Live Connection" means a prior on-premises version of SSAS Tabular, than it will not work.

 

Regards,

Tom

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Tom, It is indeed an older version of SSAS and not 2022 I am using.

Thanks.