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: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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