Azure SQL Data Warehouse Generally Available in 27 Regions Worldwide, Power BI Pro publish to Web GA

SQL Data Warehouse is a go-to SQL-based fully managed, petabyte-scale cloud solution for data warehousing. general availability of Publish to Web in Power BI Pro for Government.

Share online:

Azure SQL Data Warehouse, a petabyte-scale cloud solution, is now generally available in four additional regions – and globally, the solution is now available in total 27 regions.

With today's general availability, SQL Data Warehouse becomes the only public cloud data warehouse service that offers an availability SLA of 99.9% to customers, team Azure says.

In addition, Geo-Backups support added to allow SQL Data Warehouse Geo-Backup to be restored to any region in Azure. With this feature enabled, "backups are available even in the case of a region-wide failure, keeping your data safe," writes Azure team.

"SQL Data Warehouse enables users to provision in minutes and scale capacity in seconds and storage independently, allowing them to burst compute for complex analytical workloads or scale down their warehouse for archival scenarios."

General availability of Publish to Web in Power BI Pro for Government, announced on Monday, enable customers can to now easily embed interactive Power BI visualizations online, such as in blog posts, websites, through emails or social media, on any device.

They will also be able to easily edit, update, refresh or un-share your published visuals.

Custom Cache Refresh Schedules in the Power BI Service, gives dataset owners full control over the scheduled cache refresh cadence of DirectQuery and live connection datasets. Periodically, this cache is updated in a process called scheduled cache refresh.

Now, when DirectQuery or live connection are set up against a data source, "the Power BI service will make live queries against the data source when users interact with report visuals."

With this update, "we are setting the scheduled cache refresh cadence of all existing DirectQuery and live connection datasets to be one hour," writes the Bi team.

In addition, the service also keeps a cache for dashboard visuals created against the data source, and enables extremely quick loading of dashboards, the team said.

Custom Cache Refresh Schedules in Power BI Service
Custom Cache Refresh Schedules in Power BI Service

Microsoft Mechanics released a new video on Monday, to help learn "how Azure Analysis Services can help with semantic data models."

Released in preview last October, Azure Analysis Services, enables to host semantic data models in the cloud. it's built on the proven analytics engine in Microsoft SQL Server Analysis Services. "Users in the organization can connect to data models using tools like Excel, Power BI and many others to create reports and perform ad-hoc data analysis."

Microsoft also announced today the availability of the new Intune and Azure AD APIs in preview are now as part of the Microsoft Graph API beta, and will be generally available later in 2017.

Built on Microsoft Graph API, "the new Intune and Azure AD experience on Azure opens a new set of possibilities for customers and partners to simplify, automate, and integrate their workloads," the team said.

Microsoft Graph API serves as a single interface where Microsoft services can be reached through a set of REST APIs. It connects developers to data that drives productivity – mail, calendar, contacts, documents, directory, devices, and more.

Now with Microsoft Graph API, "customers have the choice to manage administration and operation of Intune and Azure AD services in the new Azure console or through the Microsoft Graph API," wrties Microsoft.

Microsoft Graph API Beta
Microsoft Graph API Beta

The following benefits are offered through the new Microsoft Graph API:

  • It's accessible through several platforms and tools, including REST- based API endpoints, and most popular programming and automation platforms (.NET, JS, iOS, Android, PowerShell).
  • Graph API allows to connect different services and automate workflows and processes between them.
  • Microsoft Graph API can send detailed device and application information to other IT asset management or reporting systems. You can even connect with PowerBI and other analytics services to create custom dashboards and reports based on Office 365, Intune, and Azure AD data from the Microsoft Graph API.