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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
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 😞