Forum Discussion
stream analytics as streaming dataset source
To build onto Lydia's answer:
We are currently working on having a feature to enable ASA to output to Power BI via streaming datasets. This will in turn allow you to create streaming tiles based on ASA outputs. Later this year, we plan to have a private preview for this feature. If you're interested, please PM me, and I'll add you to our private preview list.
Thanks!
-Sirui
I am also interested in creating live dashboards on Power BI, using streaming data from ASA (if possible, I would like to be notified of the private preview as well).
In the meantime, I have set up a streaming analytics service as outlined in the two links mentioned previously:
1 - https://azure.microsoft.com/en-us/documentation/articles/stream-analytics-power-bi-dashboard/
2 - http://radacad.com/stream-analytics-and-power-bi-join-forces-to-real-time-dashboard
Everything is working as expected - I am sucessfully streaming data (JSON) from my event hub to Power BI. The only problem is that the numerical values in the data are being interpreted as a string type; therefore I cannot get any of the graph visualizations to work correctly. I had the same problem when using Power BI Desktop (with data being imported from Azure table storage), however, that application allowed me to "shape" the data, and modify the data types if necessary. I simply changed the type from a string to a decimal and everything worked correctly (of course the desktop application can only create "snapshot" reports, and not real time or "live" charts).
Is there a way I can change the data type using the Power BI web application? There could be an issue with my ASA Query but the data is being transferred...
Select
timecreated,
Out,
Ex,
Rm,
Name
from devicesinput TIMESTAMP by timecreated
Thanks in advance.
sirui_sun wrote:To build onto Lydia's answer:
We are currently working on having a feature to enable ASA to output to Power BI via streaming datasets. This will in turn allow you to create streaming tiles based on ASA outputs. Later this year, we plan to have a private preview for this feature. If you're interested, please PM me, and I'll add you to our private preview list.
Thanks!
-Sirui
of the following links
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 timecreatedOf 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.