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 estab...
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


v-easonf-msft's avatar
v-easonf-msft
Community Support
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