issue with Date table in directquery

[Anonymous]

Hello all,

I am connecting to tables in SQL server in directquery mode. since I need to refresh the data every 10 min.

I have created date table in SQL and created the relationship with those tables. Also marked Date table as "Date table"

From date table, datekey datatype as Date. and then I have changed the datatype of 'Mod_Date' column as Date.

I have created a table visual and when I am trying apply month filter from date table, it is not working. Is something else, I am missing? any suggestions.

Thanks in advance.

[Fowmy]

@Anonymous 

I am not sure how you have applied the month filer and when you say "Not working", it is not clear enough. Please share a sample file and provide an explanation.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

@Fowmy Thank you for your reply.

The month filter (from Date table) is not working with table visual. it is showing blank. Month filter is not being applied.
Table fields are from SLA_Summ table.

Even if I choose 'DateKey' filter(from date table), filter does not apply.

https://1drv.ms/w/s!AmG6mTfolVuyg108gGVM0G0fgwRk?e=gV7GQF

(Shared the screen shots in attached document, somehow not able to upload here.)

Date Query - used to create date table in SQL server.

https://1drv.ms/t/s!AmG6mTfolVuyg2IjpHlpNnu08l4S?e=w4cMnL