Stream Analytics Datetime format resets for Power BI Streaming dataset

[TheKnall]

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.

[SimonLT]

Hello everyone, 

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

Thanks

Best Regards,
Simon

[v-lionel-msft]

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.

[Anonymous]

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