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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Geert_v_Hugten
New Member

Timestamp to time but gives "empty" in graph.

Hi all,

I hope my problem is described clearly, but if there are additional questions before you could give me any tips please ask! 

 

So i got data from Azure Data Explorer (Kusto) via Directquery. In the data there is a column "collectionTimestamp" containing a timestamp. Power BI seems to detect this as a date/time/timezone. 

collectiontimestamp.png

 

Because there is no automatic date hyrarchie when using Directquery i made a date hyrarchie myself. For the data that works like a charm but i cannot get the time from the column. 

I tried adding a colum via "add column --> time" but that gives a strange format of the time. There is displayd "0." before the actual time. 

tijd.png

 

The colomn is defined as a time column, but when doing that again there is an error shown: 

error.JPG

i tried investigating that error but there are no results via Google. 

 

After going back one step (so not declaring the column as a time column) i put the hole thing in a graph. At first i added the data hyrarchie and then added the time. 

hierarchie.png

 

 

The table gives a result, sorts the data and displays "(leeg)" at the place where i would expect the times to be displayed.

graph.png

 

 

I also build the report with import i.s.o. Directquery and then it all works as i would like it to work. But as i need to have the data automatically updated for viewers of the report import is not going to work. 

 

 

I hope someone can help me to point me in the right direction. 

2 REPLIES 2
amitchandak
Super User
Super User

@Geert_v_Hugten , Try a new column in power query

 

DateTime.Time([Datetime])

 

or in DAX

 

TimeValue([datetime])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

HI! 

I added a new column via power query and entered "DateTime.Time([CollectionTimestamp])" as the column formula. 

The result i got is a new column with data type "random" (i'm not sure if this translates correct. I have my language set in Dutch) and the time including the "0." in front of it. 

dataformula.JPG

 

If i then add this to the X-axis i.s.o. the other "time" column there is data shown but it is not formatted as time. 

table2.JPG

 

If i change the data type to "time" the earlier described error occurs. 

 

error2.JPG

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.