Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Date Slicer Extra Day

I have Power BI Desktop (Version: 2.41.4581.361 64-bit (November 2016) connected to SQL Server 2016 via direct query.   I have a DateDimension with a field set as Data Type: Date and is stored in t...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

I have tested this scenario in Version: 2.41.4581.361 64-bit (November 2016), I could reproduce your problem. It looks like an issue about date range slicer when selecting "Between" option. It will automatically add one day to the end date. 

 

Also, I find that this issue only occurs in direct query mode. In import mode, the date range slicer works fine to filter data.

 

Someone else coming across the same problem has submitted this issue at this page, you can click to vote it up.

 

Thanks,
Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Issue has been addressed with January release.  The direct query SQL is now generating a '<' (rather than '<=') on the extra day added to date slicer