kartikeya's avatar
kartikeya
Regular Visitor
9 years ago
Status:
Done

Issue with DateTime variables when streaming real time data

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

Dashboards

7 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    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's avatar
    kartikeya
    Regular Visitor
    9 years ago

    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

  • kartikeya's avatar
    kartikeya
    Regular Visitor
    9 years ago

    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?

Completed Ideas