Timestamp to time but gives "empty" in graph.

[Geert_v_Hugten]

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. 

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. 

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

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. 

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

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. 

[amitchandak]

@Geert_v_Hugten , Try a new column in power query

DateTime.Time([Datetime])

or in DAX

TimeValue([datetime])

[Geert_v_Hugten]

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. 

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. 

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