Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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"

gary5_2-1603537890606.png

 

gary5_0-1603537573111.png

 

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

gary5_1-1603537819480.png

 

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 2
Fowmy
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.