Azure Stream Realtime to Powerbi - Trading data

[asadhkhan]

I have a trading API i am pulling into Events hubs and using ASA to flatten and push to PowerBi.   We have few fields that are Datetime, that go down to Millisecond.   But when the data comes into PowerBi I am not able to see it to the Millisecond level, it stops at the second.   

Has anyone experienced this issue and is there a workaround?   Mind you that since this is a Real-Time push, we can not transform data I PowerBi (not allowed).

[v-stephen-msft]

Hi @asadhkhan ,

When applying filters to push datasets with DateTime fields with millisecond precision, equivalence operators are not supported. However, operators such as greater than (>) or less than (<) do operate properly.

For more information, please kindly refer to: Real-time streaming in Power BI.

Best Regards,

Stephen Tao

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

[asadhkhan]

Thank you for this info, but let me elaborate to see if I can communicate more clearly.    

Firstly, the date/time fields are not being utilized filters, it is just a straight-through passing to Power Bi.

In our trade data that is being streamed, the date/time fields are coming in epoch format (unix-time), I am applying a cast within the Query to convert to datetime format, but when it comes into powerbi, the millisecond is being dropped it off, as that field is what is used to plot on the line graph.   

I hope this helps with clarification.