Can't display visual, when using date filter in Direct Query

Question

Hi,&nbsp;&nbsp;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 data model, and updating etc., but whenever I try to add date filters to the calendar dimension I get the error posted below. When I switch to Import Mode it works fine, so I guess it has something to do with how PBI queries the data from the source.&nbsp;&nbsp;Does anyone know how to resolve this issue?&nbsp;&nbsp;&nbsp;&nbsp;

amitchandak · Answer

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 · Answer

Hi, thanks for your reply.&nbsp;&nbsp;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.&nbsp;

v-eachen-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
You could refer to this resolved case which is similar to yours.
https://community.powerbi.com/t5/Service/the-conversion-of-a-marcher-data-type-to-a-dateline-data-type/m-p/178721
&nbsp;

v-eachen-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Has your problem been solved? Was my reply helpful to you? If the problem is resolved, you could accept the reply you like.
&nbsp;

anonymous · Answer

Hi&nbsp;v-eachen-msft&nbsp;&nbsp;Unfortunately not.&nbsp;

Forum Discussion

Can't display visual, when using date filter in Direct Query

5 Replies

Related content

card visual display thousands

Visual Display based on Filter/slicer election

Date filters for Visualization

Display selected filter on this visual value per individual graph.

Line Chart Visual Axis Value Display