Date time field not showing time on table chart

[savanth]

Hi , 

 Am able to create a dataset with time component with PBI desktop. But when i push data to a dataset created via Rest api , the Datetime value is added as a String type. Isn't it possible to have datetime field in table created via rest api?

this link says it is possible http://www.microsofttrends.com/2015/02/17/pushing-data-into-power-bi-preview-using-the-new-rest-api-...

Advance Thanks 

Savanth

[bramleyd]

Hi,

Has anbody found a solution to this? I too can only add Date values.

Not being able to add the Time component seems like a fundamental issue for a service promoted for real-time dashboarding....

Regards

[Vicky_Song]

@savanth, to add rows to a dataset in your dashboard, you need to work with the Add Rows function. Rows added to the dataset actually is a collection of Column names and values. As you figured out, the Datetime time value is added as a String type:

{"rows":
    [
        {"ProductID":1,"Name":"Adjustable Race","Category":"Components","IsCompete":true,"ManufacturedOn":"07/30/2014"},
        {"ProductID":2,"Name":"LL Crankarm","Category":"Components","IsCompete":true,"ManufacturedOn":"07/30/2014"},
        {"ProductID":3,"Name":"HL Mountain Frame - Silver","Category":"Bikes","IsCompete":true,"ManufacturedOn":"07/30/2014"}
    ]
}

I can't figure out you one way how to insert a Datetime type value directly. Like when you insert a datetime type value manually in SQL, the datetime type value is surrounded with single quotation marks (' '), just the same way you're using to insert string type value. Does it make sense?