1400 Compatibility Level in Azure Analysis Services, More Announced

On-premises data gateway, preview of Consumption and Charge APIs for Enterprise Azure customers, Preview of consumption and charge APIs are now available.

Share online:

Customers now securely connect business apps in the cloud to data sources on-premises by using the On-premises Data Gateway, which is generally available in Azure Thursday.

Using the gateway, customers can move data to and from the cloud while keeping their data sources on premises. Additionally, with this update, On-premises Connectors for Azure Logic Apps is added too, and gave admins even more control over data gateway settings.

On-premises data gateway in Azure
On-premises data gateway

Microsoft says, in the next few months, the support will expand to include Azure Analysis Services.

This release includes these new features: "Support for multiple regions, Delete your gateway connection resource in Azure, New on-premises connectors for Azure Logic Apps."

To get the latest gateway installation, download the gateway installer HERE.

The new Azure Consumption and Charge APIs for Enterprise customers is now available. With this preview release, users now have the ability to query Azure Usage details and Marketplace Charges by any desired date range or billing period.

These APIs enable organizations to gain deep insights into their usage and spend for all workloads running on Azure.

Here's the detail of the APIs available today:

  • Balance and Summary API offers a monthly summary of information on balances, new purchases, Azure Marketplace service charges, adjustments, and overage charges.
  • Usage Detail API offers a daily breakdown of consumed quantities and estimated charges by an enrollment. The result also includes information on instances, meters, and departments. The API can be queried by billing period or by a specified start and end date.
  • Marketplace Store Charge API returns usage-based marketplace charges breakdown by day for the specified billing period or start and end dates.
  • Price Sheet API provides applicable rate for each meter for the given enrollment and billing period.
  • Billing Periods API returns a list of billing periods that have consumption data for the specified enrollment in reverse chronological order. Each period contains a property pointing to the API route for the four sets of data, BalanceSummary, UsageDetails, Marketplace Charges, and PriceSheet.

A public preview of the "1400 Compatibility Level" for tabular models in Azure Analysis Services, announced on Thursday, brings a host of new connectivity and modeling features for comprehensive, enterprise-scale analytic solutions delivering actionable insights.

Azure Analysis Services provides enterprise-grade data modeling in the cloud.

The 1400 compatibility level also will be available in SQL Server 2017 Analysis Services to ensure a symmetric modeling capability on premises and in the cloud.

Highlights of the new features available to 1400 models include:

  • New infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This enables:
  • Support for additional data sources, such as Azure Blob storage. Additional data sources are planned soon.
  • Data transformation and data mashup capabilities.
  • Support for BI tools such as Microsoft Excel enable drill-down to detailed data from an aggregated report. For example, when end-users view total sales for a region and month, they can view the associated order details.
  • Object-level security to secure table and column names in addition to the data within them.
  • Enhanced support for ragged hierarchies such as organizational charts and chart of accounts.
  • Various other improvements for performance, monitoring and consistency with the Power BI modeling experience.

Until now the amount of storage available to Premium Elastic Pools in Azure SQL Database was limited to 750 GB, now starting Thursday, this limit has increased to 4 TB for the largest Premium pools.

A new tool called "Azure Scheduled Events" is now available in preview, allowing users to react to and plan for maintenance events in virtual machines. Scheduled Events, one of the subservices under Azure Metadata Services, gives your application enough time to perform preventive tasks.

Premium elastic pools in Azure SQL Database chart
Table: Premium Elastic Pools in Azure SQL Database

Update 05/06: For those who could not join the April Azure Gov DC Meetup, Microsoft has now published the replay of "Enhancing Government Services Through Advanced Analytics," with the first segment kicks off with Azure Government updates then features Lisa Connelly and Bonnie Strayer of Esri's National Government Team.

In addition to providing insight to Esri and Microsoft's collaboration to provide more efficient solutions for customers, they also showcase a Chesapeake Conservancy use case.

In the second segment, Karriem Lateef, gives a highly interactive presentation that discusses a recent White House call to action around traffic fatalities and walks through the challenges and solution built.

Lastly, the third segment, features Vishwas Lele, who gave a presentation on Data Science Virtual Machine.

"DSVM is an Azure virtual machine that comes with a collection of pre-installed tools commonly used for doing data analytics and machine learning."

Esri Advanced Spatial Analytics in the Azure Cloud (Level 100):

Enhancing Government Services Through Advanced Analytics (Level 100):

Data Science Virtual Machine (Level 200):

And, in this newest episode of the Azure Friday, Steve Michelotti and Scott Hanselman talks about Azure Government, which provides a separate physical and network-isolated instance of Azure for federal, state, and local governments with a higher level of compliance for US Government workloads.

Michelotti shows how easy it is to get connected and get started with Azure Government.

Check out the full Azure Friday video library here and the video below: