Issue with DateTime variables when streaming real time data

[kartikeya]

From my observations, I think its a bug but please let me know if this problem has a definate solution.

While generating an API for Streaming data, I checked on the 'Historic data Analysis' tab and so my script stopped working due to timestamp (DateTime) value. Due to this, I changed its data type to String and everything works fine until i create a report in the service itself from this real time streaming data and here it couldnt recognize the timestamp as 'Date and time' rather it considers it as a string and thus I am unable to create any visual using the same.

Any workaround will be helpful.

Thanks

[v-haibl-msft]

@kartikeya

I cannot repro the same issue on my side. Please refer to my recorded video below. Could you please provide more info about the issue you encounter?

Best Regards,
Herbert

[kartikeya]

Yeah .. this is exactly what I want.

See I am running a python script which sends the data to Power-BI using the REST-API provided. Everything works fine until I change the dataset to 'Historic Data Analysis'. The python starts giving error (400 Bad Request) unless i cange the datatype of 'timestamp' column to Text.

After timestamp is Text, I am able to make real time visuals, but while creating a report the visuals do not consider timestamp as datetime rather show them as text due to which I cannot use the hierarchy properties.

Please have a look at attached video

[v-haibl-msft]

@kartikeya

I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page).

Best Regards,
Herbert

[kartikeya]

Hey @v-haibl-msft

I opted for the Pro trial version but still I am unable to create a support ticket. Do I need to purchase it?

[v-haibl-msft]

@kartikeya

Yes, you need to be Pro to create a support ticket.

Best Regards,
Herbert