Forum Discussion
Anonymous
6 years agoNot applicable
Can't display visual, when using date filter in Direct Query
Hi, I'm trying to set up some basic tables and visuals in Power BI Desktop, connecting to a SQL Server (2016) database using Direct Query. I have no issues accessing the data, setting up the dat...
amitchandak
6 years agoSuper User
Check the Data type of the column on both sides of the join. Or is the data type of a date is changed in power bi . Make sure it is date
Anonymous
6 years agoNot applicable
Hi, thanks for your reply.
The data type is already set to date. I'm querying both dimensions and facts. I'm trying to filter a fact table, using a date dimension if that's of any help.
- v-eachen-msft6 years agoCommunity Support
Hi Anonymous ,
You could refer to this resolved case which is similar to yours.