Forum Discussion

TheKnall's avatar
TheKnall
Frequent Visitor
6 years ago

Stream Analytics Datetime format resets for Power BI Streaming dataset

Hi

I have encountered a strange behavior that might have something to do with  the output of a stream analytics job to Power BI. We have created an output job in Stream Analytics, that publishes to Power BI streaming dataset.  The job creates a Power Bi streaming dataset and the default format for datetime becomes a text field.  By going into the dataset (after created) and changing the format from text to Datetime fixes the problem. But when a  SAjob is stoped and started again the format goes back to a test field again. (I think it overwrites the dataset)

The vaule for Datetime that I am sending is in "2020-01-08T14:44:36Z". This is the same as the example that is shown as an example when you manualy create a new streaming dataset i Power BI service. I suspect that we maybe need to change the Datetime format to dropp the timezone...

So the question again is, how can we make the format permanent on the Streaming dataset.

Any ideas?

Thx for all replys.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    There might be a bug in MS Stream. This kind of bug generally occurs in MS Stream. You can contact the support team and raise a ticket they can help you with exact solution.

    Regards,

    Lewis

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support

    Hi TheKnall ,

    I also agree with you, maybe the data set is overwrited.

    Maybe ypu can Create support ticket 

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Hello everyone, 

    is there already a solution for this problem? I need help with this too.

    Thanks


    Best Regards,
    Simon