Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Dates not being recognised correctly in Power BI Service

Submitted by Anonymous on ‎06-22-2017 03:11 AM

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
See more ideas labeled with:
2 Comments (2 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎06-23-2017 02:42 AM

@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
‎06-27-2017 08:17 AM

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

Idea Statuses