Incorrect dates in power bi desktop, in power bi online is fine

[guibenassi]

In Power BI desktop occurs a problem with my date, just in 01 November 2020.

When I publish the report it works fine.

I create a very simple table with just a calendar to demonstrate the problem.

The images above shows the example.

when I select the range from October 31 and November 01, shows normal, when I select just the day 01/11/2020 , the table not show the date 01/11/2020.

The same error don´t occur in Power BI Online, as shown.

[guibenassi · Accepted solution]

Microsoft releases the December 2020 update at https://www.microsoft.com/en-us/download/details.aspx?id=58494  and the issue was resolved. Thanks for all that have contributed with that.

Thanks

Mariana Mclaughlin

[guibenassi]

Good News.
Microsoft told me that the issue will be resolved in December 2020 update.

For a turnaround solution I change my timezone from Brasilia GMT -3 to Buenos Aires GMT -3, with this turnaround I can work without problems.

[marcions]

What was the solution applied?

[guibenassi]

There is no solution so far.
Microsoft is still working on it.

[MatheusLPS]

I have the same problem here.

All dates:

Filtering from 01/11/2020: 

"Solved" by editing the slicer on the webservice.

[guibenassi]

We can identified a problem together wiht Microsoft support with the TimeZone and the function between in the slicer.

All the way the problem is not resolved so far.

I will report an issue as recommeded.

Thank you

[v-deddai1-msft]

Hi @marcions ,

Not very sure. I test in PT-BR (Brazil) format. It showed as expected. 

I suggest you report this as an Issue using issues.powerbi.com.  first check to see if it has already been reported.   

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[marcions]

Hi,

I did a new test and the problem continues.

I realized that in my version I am using the date in PT-BR (Brazil) format.

The problem happens only when the filter is applied with the slicer and the Between option.

Using the slicer with the Relative Date option works correctly.

[guibenassi]

When I don´t use the slider, and use the page filter works fine.

[guibenassi]

If I start the date with 01/11/2020 it not shows in my report,
If I start before that it shows normal.
I tried the August 2020 version of Power Bi, but the problem continues.

[Anonymous]

I cannot reproduce this issue. What happens if you extend you calender to 02 november ?

[v-deddai1-msft]

Hi @marcions ,

I have test it in the same version of you in my environment. I can't reproduce your issue. Would you please try again?  As a workaround, you can use the previous version of power bi desktop: https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[marcions]

Hi,

I did a new test and the problem continues.

I realized that in my version I am using the date in PT-BR (Brazil) format.

The problem happens only when the filter is applied with the slicer and the Between option.

Using the slicer with the Relative Date option works correctly.

[marcions]

I have the same problem

[guibenassi]

Amit, there is no other filter in the report.

I create a new report with nothing, I just create a Calendar Table via DAX

Calendar = Calendar(Date(2020,10,01),Date(2020,11,01))

I have just this table and nothing else.
In the report I just drag the slicer and the table.

I am using the November/2020 release

[amitchandak]

@guibenassi , I tried the same on my data. I am able to see that. And I am on Nov 2020 release.  Just check for any other filter on the page.