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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Dates not being recognised correctly in Power BI Service

I have unsual behavior involving dates. I have made a slicer based on date, it's working perfectly fine in Power BI Desktop:

 

PBIDesktop.JPG

 

But once I uploaded it on the Power BI Service, The dates are ruined

 

PBIService.JPG

 

It came to a point that I accedentally visitied the year 1899 and I can no longer get out of it as the slicer is disabled:PBIService-1899.JPG

 

When we use the dates in a visuals you can clearly see the date being reflected as December 1899 instead of the latest month/year:

image.png

 

I have a SAP HANA data source in direct query in which it gets data for those dates.

 

Status: New
Comments
v-haibl-msft
Microsoft Employee

@Anonymous

 

I cannot repro the same issue on my side. Please make sure that you are using the latest version of on-premises gateway.

If issue persist, I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page).

 

Dates not being recognised correctly in Power BI Service_1.jpg

 

Support Ticket.gif

 

Best Regards,
Herbert

 

Anonymous
Not applicable

Too bad I only have the Power BI Pro (Free trial), I can;t create a support ticket 😞