Forum Discussion

asadhkhan's avatar
asadhkhan
Frequent Visitor
5 years ago

Azure Stream Realtime to Powerbi - Trading data

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 Po...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
asadhkhan
Frequent Visitor
5 years ago

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.