Forum Discussion

sunjin122's avatar
sunjin122
Helper I
10 years ago
Solved

Live data filter doesn't work

I am trying to make a report with live data. I load my data from SQL Server by using Direct Query. I made few charts and filters. All filters are working well, except the Date filter, everytime when ...
  • pqian's avatar
    pqian
    10 years ago

    sunjin122 this is a limitation for DirectQuery, since you are connected directly to the data source, you can't really alter the schema in a non-relational manner (text->date). One indication is this operation isn't allowed in the query editor due to folding. Changing the format can alter how the column is rendered in the report, but the semantics of cross filtering also changes, hence it didn't execute.

     

    It's better if you keep this column in text format, or change the type in the data source.

pqian's avatar
pqian
Microsoft Employee
10 years ago

sunjin122 this is a limitation for DirectQuery, since you are connected directly to the data source, you can't really alter the schema in a non-relational manner (text->date). One indication is this operation isn't allowed in the query editor due to folding. Changing the format can alter how the column is rendered in the report, but the semantics of cross filtering also changes, hence it didn't execute.

 

It's better if you keep this column in text format, or change the type in the data source.

  • sunjin122's avatar
    sunjin122
    Helper I
    10 years ago

    pqianThank you for your help!