Forum Discussion

mthirty's avatar
mthirty
Frequent Visitor
6 years ago
Solved

Relative Date Filter - Analysis Services Live Connection

Hello,

I am wondering if it is possible to use the Relative Date filter options when connecting Live to a SQL Server Analysis Services data source? If so, what are the field settings I need to establish in SSAS to make this feature available?

Thanks!

 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi ， mthirty 

    If you use the "Connect Live" option to connect to the data model(my model is a Tabular project not MultidimensionalProject), make sure the type of your date is "date" not " text" in SSAS. 

     



    Best Regards,
    Community Support Team _ Eason


2 Replies