Forum Discussion
issue with Date table in directquery
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.
2 Replies
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 🙂
@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
