Last week Microsoft finally updated Microsoft Azure Stream Analytics with great new features. In this blogpost I explain some new features I use in our projects now.
Using custom code in your Microsoft Stream Analytics Query
First of all you go to your Microsoft Stream Analytics job and select ‘Function’ and add a new one:
Visual Studio integration for Azure Stream Analytics
One challenge I have with creating queries in Azure Stream Analytics (yes, I am not the best with SQL..) is testing my queries with the data input. I was costing me a lot of time. I was the last weeks part of a private preview of the integration of Azure Stream Analytics in Visual Studio. That is now in public preview(download here). With this add-in you can export (or import) your Microsoft Stream Analytics projects in Visual Studio and test everything locally! Currently only Visual Studio 2015 is supported.
First or all go to your Server Explorer and navigate to Stream Analytics and hit the export button.
2. Then your complete stream analytics project is exported to Visual Studio 2015. Here you get some great functionalities
Syntax Highlighting in your queries
You can write your query and test it directly to testdata! Just hit F5!
You have off course directly integration with TFS / source control
Low-latency dashboards in Power BI
Another new update is low latency support in your Microsoft Power BI output of Azure Stream Analytics. (Power BI streaming sets). The latency is now much better then some weeks ago. So you get faster insights in your data!
Other new functionalities:
Native support for Geospatial functions; now you can define geographical areas in your Azure Streaming job.
Job Diagnostics logs; there is now an integration with Azure Monitoring to better monitor your Stream Analytics Jobs!
The last few months I wss busy with a SmartBuilding solution for some of our education clients to save square meters and give an app to studenten to find free rooms. Later I will create several post about the technical solution, but I have created (sorry its in dutch) white paper about this topic.
Microsoft just updated a news version for Microsoft Power BI with the following update:
Report View ArcGIS Maps for Power BI (Preview)
Mobile report layout (Preview)
Updated drill behavior
Use your own R IDE
Snowflake Connector DirectQuery Support
Oracle Connector – Improved Navigator Previews Performance
OData Connector – Support for “Select Related Tables” option
SAP BW and SAP HANA Connectors – Enhancements to parameter input UX
Web Connector – UX Support for specifying HTTP Request Headers
Query Editing Query Dependencies view
Show Errors experience
Query Editor Ribbon Support for Scalar Values
Add Function Invocation Column
Expand & Aggregate Columns – Support for “Load More” values
New Transform – Convert Table Column to a List
Keyboarding – Support for “smart typing” in dropdown menus