Showing results for 
Search instead for 
Did you mean: 
mvoss12 Frequent Visitor
Frequent Visitor

Time in Measure showing as Zeros!

We are using an Analysis Services tabular cube as our data source.  We had an existing dashboard where this was working, but now an issue appeared (related to a new version of Power BI service?)


A date/time measure shows both the date and time correctly in Power BI Desktop, but when I publish and look at it in the Power BI Service, the date is correct but the time portion shows ALL Zeros!


Power BI Desktop shows value of measure as:  5/27/16 9:50:06


Power BI Services shows value of measure as:  5/27/16 0:00:00


Is anyone else having the same issue?  Thanks for any help you can provide!


mvoss12 Frequent Visitor
Frequent Visitor

Re: Time in Measure showing as Zeros!

I have discovered that if I use the field directly in the Power BI Service it works, but if I publish from Power BI Desktop (which is our standard practice here so we can put our reports in Source Control), then it changes the time to zeros.


Is anyone else publishing a date/time field from Power BI Desktop and if so, can you check your time to see if it is showing zeros?


Thank you!




ankitpatira Super Contributor
Super Contributor

Re: Time in Measure showing as Zeros!

@mvoss12 I also noticed similar to your issue. When publishing from power bi desktop even when datetime was selected and not as hierarchy in power bi service it converted and showed it in hierarcy. I would report this issue here.


Helpful resources

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 1,695 guests
Please welcome our newest community members: