Azure Updates - Latest from Azure Charts

Part 2: Migrate Azure Analysis Services to Power BI Premium using Azure Databricks - How-To

Wed, 29 May 2024 23:02:30 Z

This post is authored in conjunction with Leo Furlong, Senior Solutions Architect, at Databricks. Many customers choose to migrate their Azure Analysis Services semantic models to Power BI Premium due to the benefits and enhanced functionality described in the Power BI documentation. As customers migrate their semantic models to Power BI, native connections to Azure Databricks SQL become available due to the built-in Databricks SQL connector in Power BI. Databricks SQL Serverless combined with Power BI semantic models can provide customers with a number of benefits including a separation of compute and storage; instant, elastic compute; data refreshes charged by the second; and enterprise Data Warehouse functionality, query performance, and concurrency at any scale. The remainder of this article will focus on the in-and-outs of how to accomplish this migration. Requirements You must use Power BI Premium Capacities. This means that P, A4+, or F SKUs are required. The XMLA endpoint for your Power BI workspace must be configured for Read/Write. You will need Tabular Editor 2 or Tabular Editor 3 to migrate your semantic model to Databricks SQL. Tabular Editor is a 3rd party tool featured by Microsoft. Migrating an existing semantic model to use Databricks SQL requires that your existing data source is a structured data source (PowerQuery based connection). Limitations AAS models migrated to Power BI Premium can’t be edited using web authoring per the documented limits, but as of writing this post, it does appear to allow web authoring on migrated models without issues/errors AAS models migrated to Power BI can’t be downloaded to Power BI Desktop Parallel connection configuration is only available in model Compatibility Level 1600+ Assumptions Your data model in Databricks SQL is in the same structure as your current Azure Analysis Services model in terms of table/column names and column data types. You are using the same Power BI s
Update Type: Announcement, Services: Databricks, Analysis Services, Power BI Embedded, Categories: Services

Part 1: Migrate Azure Analysis Services to Power BI Premium using Azure Databricks - Why

Wed, 29 May 2024 23:02:10 Z

This post is authored in conjunction with Leo Furlong, Senior Solutions Architect, at Databricks. In the world of data analytics and business intelligence, the tools and platforms you use can significantly impact the efficiency and capabilities of your data operations. Two major shifts in the landscape are the migration from Azure Analysis Services to Power BI Premium and the move to Azure Databricks SQL as the underlying data source for Power BI. Let's dive into why these changes are worth considering. Migrating from Azure Analysis Services to Power BI Premium Azure Analysis Services has been a staple in the enterprise semantic layer toolset, providing robust semantic layer capabilities. It's the same engine that powers Power BI under the hood, which means there's a shared lineage and compatibility between the two services. However, Power BI has evolved rapidly and now offers a superset of functionalities that were once exclusive to Azure Analysis Services. Here are some compelling reasons to migrate: Enhanced Functionality: Power BI Premium has grown to encompass all the capabilities of Azure Analysis Services and then some. A feature comparison matrix is provided here. Tool Consolidation: By migrating to Power BI Premium, organizations can consolidate their semantic layer and BI tools into a single platform. This not only simplifies the architecture but also reduces the overhead associated with maintaining multiple systems. Microsoft's Direction: Microsoft itself recommends that customers transition their Azure Analysis Services models to Power BI Premium. This is a strong indicator of the strategic direction Microsoft is taking, with Power BI Premium positioned as the go-to enterprise semantic layer solution. For more details on this migration, you can refer to Microsoft's official documentation here. Moving to Azure Databricks SQL for Power BI Azure Databricks SQL offers a modern and optimized approach to handling present and future data analytics cha
Update Type: Announcement, Services: Databricks, Analysis Services, Power BI Embedded, Categories: Services

Azure Analysis Services integration with VNets via On-Premises Data Gateway

Tue, 24 Apr 2018 00:00:00 -0700

We are pleased to announce Azure Analysis Services now provides integration with cloud data sources residing on Azure Virtual Networks (VNets). Organizations use VNets for enhanced security and isolation. Cloud data sources such as Azure SQL DW and Azure Database can be secured with VNet endpoints.
Update Type: Announcement, Services: Analysis Services, SQL Database, Virtual Network, Categories: Services

Announcing Azure Analysis Services general availability

Wed, 19 Apr 2017 00:00:00 -0700

Today at the Data Amp event, we are announcing the general availability of Microsoft Azure Analysis Services, the latest addition to our data platform in the cloud.
Update Type: Announcement, Services: Analysis Services, Categories: Services