Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

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

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @Aaron_Coughlan ,

 

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey @Aaron_Coughlan ,

 

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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

Thanks.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors