Forum Discussion
stream analytics as streaming dataset source
Hello - unfortunately, there's no easy way to change the data type in the Power BI web application.
I would suggest updating the ASA query to explicitly cast the fields that you want to be numbers:
https://msdn.microsoft.com/en-us/library/azure/dn834995.aspx
https://msdn.microsoft.com/en-us/library/azure/dn835065.aspx
Once you cast the field, ASA should update the type in Power BI as part of outputting the field.
Let me know if that works!
Yes, it worked perfectly. The revised ASA query is shown below. Can I be informed of the ASA streaming dataset private preview when it becomes available?
Thanks.
Select
CAST (timecreated AS datetime) as timecreated,
CAST (Out AS bigint) as Out,
CAST (Ex AS bigint) as Ex,
CAST (Rm AS bigint) as Rm,
Name
from devicesinput TIMESTAMP by timecreated
Of course. Please PM me with your e-mail address, and I will add you to the private preview list. When private preview begins, I will reach out with next steps.
When will this feature be released?
Can you add me to the preview as well?
Hi sirui_sun,
I already PM you for joining the private preview list
