{"id":14224,"date":"2018-11-07T10:25:43","date_gmt":"2018-11-07T09:25:43","guid":{"rendered":"https:\/\/www.inovex.de\/blog\/?p=14224"},"modified":"2026-03-17T07:59:29","modified_gmt":"2026-03-17T06:59:29","slug":"modern-data-warehouse-azure-analysis-services","status":"publish","type":"post","link":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/","title":{"rendered":"Rethinking Modern Data Warehouse with Azure Analysis Services"},"content":{"rendered":"<p>Before I got more familiar with Microsoft Azure and all its PaaS components such as Azure Analysis Services, I was routinely sticking to Microsoft\u2019s on-premises BI stack. With this constrained view on technologies, also some restrictions in terms of cloud-based technology re-interpretations came along.<!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><p class=\"ez-toc-title\" style=\"cursor:inherit\"><\/p>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#What-actual-scenario-do-I-want-to-point-out\" >What actual scenario do I want to point out?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#Is-there-maybe-something-we-dont-see\" >Is there maybe something we don\u2019t see?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#How-to-feed-Azure-Analysis-Services-directly-from-Azure-Blob-Storage-or-Azure-Data-Lake-Store\" >How to feed Azure Analysis Services directly from Azure Blob Storage or Azure Data Lake Store<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#1-Work-with-subsets-of-the-data\" >1. Work with subsets of the data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#2-Keep-data-management-and-performance-requirements-in-mind\" >2.\u00a0Keep data management and performance requirements in mind<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#3-Parallelized-incremental-loads-on-the-deployed-Tabular-Model\" >3.\u00a0Parallelized incremental loads on the deployed Tabular Model<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#Summary\" >Summary<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#Read-On\" >Read On<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"What-actual-scenario-do-I-want-to-point-out\"><\/span><em>What actual scenario do I want to point out?<\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once, we all were cloud virgins\u2026 imagine the following situation: you have your SQL Server Data Warehouse on-premises with regular relational tables and you are using a Tabular Model on top of it. You are building fancy dashboards and hosting them on your Power BI Report Server or you have them running in the PowerBI service. Doesn\u2019t sound new to you, right!?<\/p>\n<p>Now you can do this sort of stuff in Azure. It\u2019s the Modern Data Warehouse approach (for more details on MDWH check\u00a0<a href=\"https:\/\/azure.microsoft.com\/en-us\/solutions\/data-warehouse\/\">this<\/a>\u00a0out). \u201c<em>I know!\u201c<\/em> \u2026most would say by now. <strong>However,<\/strong> what I have experienced in most customer contexts, is that people are aware of this rigid, classical approach using a relational component, either Azure SQL (managed instance) or Azure SQL Data Warehouse, on top of their data lakes with subsequently attaching an Azure Analysis Services Instance hosting some Tabular Models on top of it.<\/p>\n<p>This is what such a typical MDWH cloud architecture could look like:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-14226\" src=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/10\/MDWH_BlogPost-300x233.png\" alt=\"typical MDWH cloud architecture with Azure Analysis Services on top\" width=\"495\" height=\"385\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Is-there-maybe-something-we-dont-see\"><\/span><em>Is there maybe something we don\u2019t see?<\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are many good reasons to use relational components, such as SQL DW for instance, especially for big workloads, considering scalability, reliability, as well as available skillsets in the SQL context. Another reason is to have an infrastructure that helps you delegate tasks to dedicated teams in the context of ETL or data reliability and consistency. I really do not want to understate the importance of one accurate and trustworthy source of truth for BI solutions.<\/p>\n<p>On the other hand, we may also face scenarios where we do not need to store data historically (SCD) or where our master data gets fully loaded each day according to given prerequisites by source systems. A big data context could also be legit, where we may not have the need for a classical data modeling approach. Maybe we want to visualize a massive amount of data. For such scenarios, a relational component between data lake and Azure Analysis Services may be causing overhead.<\/p>\n<p><em>So why not lift our file-based data directly to Azure Analysis Services!?<\/em><em>\u00a0<\/em><\/p>\n<p>You may ask yourself, how can this be done?! Is it even possible? In the following sections, I want to briefly outline how, indeed, this can be achieved.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How-to-feed-Azure-Analysis-Services-directly-from-Azure-Blob-Storage-or-Azure-Data-Lake-Store\"><\/span><em>How to feed Azure Analysis Services directly from Azure Blob Storage or Azure Data Lake Store<\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Assuming we have a nice set of files available in our storage, we can start pretty straightforward. The good news is, we have all required connectors available in the current version of SQL Server Data Tools (SSDT) for Tabular projects.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-14227\" src=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/10\/Connectors__BlogPost-300x178.png\" alt=\"A screenshot of Azure Analysis Services connectors\" width=\"486\" height=\"288\" \/><\/p>\n<p>This has some straightforward implications on our possible architecture, which could simply look like the following:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-14225\" src=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-22-um-15.46.28-300x105.png\" alt=\"Arrows pointing from Blob Storage to Azure Analysis Services\" width=\"414\" height=\"145\" srcset=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-22-um-15.46.28-300x105.png 300w, https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-22-um-15.46.28-400x140.png 400w, https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-22-um-15.46.28-360x126.png 360w, https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-22-um-15.46.28.png 547w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/p>\n<p>However, you have to watch out how files are recognized by the storage connectors. Files in a particular storage location are not recognized as single tables. All contents of a blob storage or a particular Data Lake Store represent a tabular structure:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-14228\" src=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/10\/TableStructure_BlogPost-300x224.png\" alt=\"Screenshot of a tabular structure\" width=\"579\" height=\"432\" \/><\/p>\n<p>Now if you want to create tabular models out of your files you have multiple approaches to do so. Either you accomplish the task programmatically by using Tabular Object Model (TOM) or you choose to work with SSDT, in particular, the Power Query Editor and the Advanced Editor.<\/p>\n<p>In this blog post, I want to sketch the approach via SSDT and the Power Query Editor. However, please note that you should have the May 2017 Release of SSDT in order to be able to perform the approaches briefly presented in this blog post. <strong>Compatibility Mode 1400<\/strong> is of major importance!<\/p>\n<p>In general, if we talk about large-scale tabular models, we can think of an Azure hosted model of 400 GB cache size. Thanks to the VertiPaq Engine we can achieve a maximum of 10x compression rates so that we could think of loading terabytes of file data in our model.<\/p>\n<p>There are three major aspects which you need to take into consideration when working with this file-based approach in Azure Analysis Services:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1-Work-with-subsets-of-the-data\"><\/span><em>1. Work with subsets of the data<\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If we consider working with terabytes of data in sets of multiple bigger and smaller files, we, in most cases, will not have the resources to load all that data in an instance of Azure Analysis Services, even though SSDT would also try to load all the data into your workspace server. There may be downsides on the storage level but also on the processing side. Therefore, it is advisable working with a representable subset of your data and later on during deployment switching the source of your data to the original files.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2-Keep-data-management-and-performance-requirements-in-mind\"><\/span><em>2.\u00a0<\/em><em>Keep data management and performance requirements in mind<\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A possible big data scenario would include loading a vast number of files of all different size ranges in a Tabular Model 1400. In this context we face a few challenges:<\/p>\n<ul>\n<li>Handle metadata correctly (table names, headers, etc. as possible source files may be lacking in terms of metadata)<\/li>\n<li>Combine files so that all data needed is together<\/li>\n<li>Find a way to process these amounts of data efficiently<\/li>\n<\/ul>\n<p>How can we overcome these challenges?<\/p>\n<p>The first step is to create a source query for our desired starting table by using the Query Builder in SSDT. In the next step, we can combine the remaining files for the table. During these steps, the Query Builder automatically creates some expressions. However, especially in the context of expressions you need to be careful because by adding new tables (based on files), the Query Builder will add more and more expressions. So, along the way to your final Tabular Model, you will definitely need to do some cleaning to avoid clutter. Try relying on global functions to do the work for you. By doing so you would then also include the handling of the necessary metadata like object names and headers. Technically this is all handled in M functions. But for the purpose of giving you a rough idea I am not digging into the details.<\/p>\n<p>Let\u2019s assume we have loaded our (small) required tables into SSDT and finished designing the model. Now is the time to deploy it on Azure!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3-Parallelized-incremental-loads-on-the-deployed-Tabular-Model\"><\/span><em>3.\u00a0<\/em><em>Parallelized incremental loads on the deployed Tabular Model<\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Once the model is deployed, we are switching to SQL Server Management Studio. SSMS allows us to directly connect to our Tabular Model. It enables us to perform several operations against our deployed model, such as <em>incremental data loads <\/em>for efficient data processing.<\/p>\n<p>For incremental data loads, we need to create partitions in the tables within AAS. Partitions in the AAS context will not improve query performance, but they will definitely improve the processing time as they facilitate parallelism in terms of processing. The MS Analysis Services Product Team performed a pretty impressive test in this context. They have managed to load 1 TB of TPC-DS (Decision Support Benchmarking Data) in less than 12 hrs by using partitions on their S9 AAS (28 parallelly running partitions). In contrast a single (no) partition full load takes more than 21 hrs.<\/p>\n<p><em>What are factors that determine the processing speed?<\/em><\/p>\n<p>As the Analysis Services Product Team also stated, excessive partitioning will not produce noteworthy gains, however, more sophisticated data sources will definitely help. And now we are talking about components like SQL DW again. They were able to load the entire 1 TB data set into SQL DW via PolyBase\u00a0within 2 hrs and transfer the data to AAS within 9 hrs.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Summary<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>At the end of the day use cases define which technology setup makes the most sense, but despite the commonly known approaches, we have seen that Azure Analysis Services is able to consume data from a variety of sources including storages like Azure Blob Storage or Azure Data Lake Store. You can find a very detailed instruction on how to re-build this solution in several blog posts by the Microsoft Azure Analysis Services Product Team:<\/p>\n<ul>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2017\/05\/15\/building-an-azure-analysis-services-model-on-top-of-azure-blob-storage-part-1\/\">https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2017\/05\/15\/building-an-azure-analysis-services-model-on-top-of-azure-blob-storage-part-1\/<\/a><\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2017\/05\/30\/building-an-azure-analysis-services-model-on-top-of-azure-blob-storage-part-2\/\">https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2017\/05\/30\/building-an-azure-analysis-services-model-on-top-of-azure-blob-storage-part-2\/<\/a><\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2017\/06\/22\/building-an-azure-analysis-services-model-on-top-of-azure-blob-storage-part-3\/\">https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2017\/06\/22\/building-an-azure-analysis-services-model-on-top-of-azure-blob-storage-part-3\/<\/a><\/li>\n<\/ul>\n<p>If you have questions to this kind of setup or if you would like to try this out, feel free to contact us. Besides that, thanks to the Analysis Services Product Team for their efforts in sharing their knowledge! ??<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Read-On\"><\/span>Read On<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Find out more about our\u00a0<a href=\"https:\/\/www.inovex.de\/de\/leistungen\/analytics\/\">analytics services<\/a>, including Microsoft BI,\u00a0<a href=\"https:\/\/www.inovex.de\/de\/leistungen\/applications\/\">app\u00a0and\u00a0web development<\/a>\u00a0on our <a href=\"https:\/\/www.inovex.de\/de\/\">website<\/a>. If you\u2019re looking for a job in this field head over to our\u00a0current job offers!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Before I got more familiar with Microsoft Azure and all its PaaS components such as Azure Analysis Services, I was routinely sticking to Microsoft\u2019s on-premises BI stack. With this constrained view on technologies, also some restrictions in terms of cloud-based technology re-interpretations came along.<\/p>\n","protected":false},"author":91,"featured_media":14316,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"ep_exclude_from_search":false,"footnotes":""},"tags":[181],"service":[446],"coauthors":[{"id":91,"display_name":"Eli Mirvic","user_nicename":"emirvic"}],"class_list":["post-14224","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-business-intelligence","service-business-intelligence"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Rethinking Modern Data Warehouse with Azure Analysis Services<\/title>\n<meta name=\"description\" content=\"Azure Analysis Services is able to consume data from a variety of sources including storages like Azure Blob Storage or Azure Data Lake Store. Here&#039;s how you lift our file-based data directly to Azure Analysis Services.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rethinking Modern Data Warehouse with Azure Analysis Services\" \/>\n<meta property=\"og:description\" content=\"Azure Analysis Services is able to consume data from a variety of sources including storages like Azure Blob Storage or Azure Data Lake Store. Here&#039;s how you lift our file-based data directly to Azure Analysis Services.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/\" \/>\n<meta property=\"og:site_name\" content=\"inovex GmbH\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inovexde\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-07T09:25:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-17T06:59:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/11\/Modern-Data-Warehouse-with-Azure-Analysis-Services.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Eli Mirvic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/11\/Modern-Data-Warehouse-with-Azure-Analysis-Services-1024x576.png\" \/>\n<meta name=\"twitter:creator\" content=\"@inovexgmbh\" \/>\n<meta name=\"twitter:site\" content=\"@inovexgmbh\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eli Mirvic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"7\u00a0Minuten\" \/>\n\t<meta name=\"twitter:label3\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data3\" content=\"Eli Mirvic\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/\"},\"author\":{\"name\":\"Eli Mirvic\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#\\\/schema\\\/person\\\/94bd0e180b2139b0647c4e45414e8799\"},\"headline\":\"Rethinking Modern Data Warehouse with Azure Analysis Services\",\"datePublished\":\"2018-11-07T09:25:43+00:00\",\"dateModified\":\"2026-03-17T06:59:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/\"},\"wordCount\":1451,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.inovex.de\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Modern-Data-Warehouse-with-Azure-Analysis-Services.png\",\"keywords\":[\"Business Intelligence\"],\"articleSection\":[\"Analytics\",\"English Content\",\"General\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/\",\"url\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/\",\"name\":\"Rethinking Modern Data Warehouse with Azure Analysis Services\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.inovex.de\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Modern-Data-Warehouse-with-Azure-Analysis-Services.png\",\"datePublished\":\"2018-11-07T09:25:43+00:00\",\"dateModified\":\"2026-03-17T06:59:29+00:00\",\"description\":\"Azure Analysis Services is able to consume data from a variety of sources including storages like Azure Blob Storage or Azure Data Lake Store. Here's how you lift our file-based data directly to Azure Analysis Services.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.inovex.de\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Modern-Data-Warehouse-with-Azure-Analysis-Services.png\",\"contentUrl\":\"https:\\\/\\\/www.inovex.de\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Modern-Data-Warehouse-with-Azure-Analysis-Services.png\",\"width\":1920,\"height\":1080,\"caption\":\"Two comical canons with the logos of azure data lake and azure blob storage firing files at a cloud with the logo of azure cloud services\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/modern-data-warehouse-azure-analysis-services\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rethinking Modern Data Warehouse with Azure Analysis Services\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#website\",\"url\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/\",\"name\":\"inovex GmbH\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#organization\",\"name\":\"inovex GmbH\",\"url\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.inovex.de\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/inovex-logo-16-9-1.png\",\"contentUrl\":\"https:\\\/\\\/www.inovex.de\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/inovex-logo-16-9-1.png\",\"width\":1921,\"height\":1081,\"caption\":\"inovex GmbH\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/inovexde\",\"https:\\\/\\\/x.com\\\/inovexgmbh\",\"https:\\\/\\\/www.instagram.com\\\/inovexlife\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/inovex\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UC7r66GT14hROB_RQsQBAQUQ\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#\\\/schema\\\/person\\\/94bd0e180b2139b0647c4e45414e8799\",\"name\":\"Eli Mirvic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bdea3bf8a303619afe38d1c0af6a35fa73bbac97d273abbeef0b217b63d73f5f?s=96&d=retro&r=g53c3356afde169311a2a2167df167d84\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bdea3bf8a303619afe38d1c0af6a35fa73bbac97d273abbeef0b217b63d73f5f?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bdea3bf8a303619afe38d1c0af6a35fa73bbac97d273abbeef0b217b63d73f5f?s=96&d=retro&r=g\",\"caption\":\"Eli Mirvic\"},\"url\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/author\\\/emirvic\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Rethinking Modern Data Warehouse with Azure Analysis Services","description":"Azure Analysis Services is able to consume data from a variety of sources including storages like Azure Blob Storage or Azure Data Lake Store. Here's how you lift our file-based data directly to Azure Analysis Services.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/","og_locale":"de_DE","og_type":"article","og_title":"Rethinking Modern Data Warehouse with Azure Analysis Services","og_description":"Azure Analysis Services is able to consume data from a variety of sources including storages like Azure Blob Storage or Azure Data Lake Store. Here's how you lift our file-based data directly to Azure Analysis Services.","og_url":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/","og_site_name":"inovex GmbH","article_publisher":"https:\/\/www.facebook.com\/inovexde","article_published_time":"2018-11-07T09:25:43+00:00","article_modified_time":"2026-03-17T06:59:29+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/11\/Modern-Data-Warehouse-with-Azure-Analysis-Services.png","type":"image\/png"}],"author":"Eli Mirvic","twitter_card":"summary_large_image","twitter_image":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/11\/Modern-Data-Warehouse-with-Azure-Analysis-Services-1024x576.png","twitter_creator":"@inovexgmbh","twitter_site":"@inovexgmbh","twitter_misc":{"Verfasst von":"Eli Mirvic","Gesch\u00e4tzte Lesezeit":"7\u00a0Minuten","Written by":"Eli Mirvic"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#article","isPartOf":{"@id":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/"},"author":{"name":"Eli Mirvic","@id":"https:\/\/www.inovex.de\/de\/#\/schema\/person\/94bd0e180b2139b0647c4e45414e8799"},"headline":"Rethinking Modern Data Warehouse with Azure Analysis Services","datePublished":"2018-11-07T09:25:43+00:00","dateModified":"2026-03-17T06:59:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/"},"wordCount":1451,"commentCount":3,"publisher":{"@id":"https:\/\/www.inovex.de\/de\/#organization"},"image":{"@id":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/11\/Modern-Data-Warehouse-with-Azure-Analysis-Services.png","keywords":["Business Intelligence"],"articleSection":["Analytics","English Content","General"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/","url":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/","name":"Rethinking Modern Data Warehouse with Azure Analysis Services","isPartOf":{"@id":"https:\/\/www.inovex.de\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#primaryimage"},"image":{"@id":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/11\/Modern-Data-Warehouse-with-Azure-Analysis-Services.png","datePublished":"2018-11-07T09:25:43+00:00","dateModified":"2026-03-17T06:59:29+00:00","description":"Azure Analysis Services is able to consume data from a variety of sources including storages like Azure Blob Storage or Azure Data Lake Store. Here's how you lift our file-based data directly to Azure Analysis Services.","breadcrumb":{"@id":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#primaryimage","url":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/11\/Modern-Data-Warehouse-with-Azure-Analysis-Services.png","contentUrl":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/11\/Modern-Data-Warehouse-with-Azure-Analysis-Services.png","width":1920,"height":1080,"caption":"Two comical canons with the logos of azure data lake and azure blob storage firing files at a cloud with the logo of azure cloud services"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inovex.de\/de\/blog\/modern-data-warehouse-azure-analysis-services\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inovex.de\/de\/"},{"@type":"ListItem","position":2,"name":"Rethinking Modern Data Warehouse with Azure Analysis Services"}]},{"@type":"WebSite","@id":"https:\/\/www.inovex.de\/de\/#website","url":"https:\/\/www.inovex.de\/de\/","name":"inovex GmbH","description":"","publisher":{"@id":"https:\/\/www.inovex.de\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inovex.de\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/www.inovex.de\/de\/#organization","name":"inovex GmbH","url":"https:\/\/www.inovex.de\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.inovex.de\/de\/#\/schema\/logo\/image\/","url":"https:\/\/www.inovex.de\/wp-content\/uploads\/2021\/03\/inovex-logo-16-9-1.png","contentUrl":"https:\/\/www.inovex.de\/wp-content\/uploads\/2021\/03\/inovex-logo-16-9-1.png","width":1921,"height":1081,"caption":"inovex GmbH"},"image":{"@id":"https:\/\/www.inovex.de\/de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inovexde","https:\/\/x.com\/inovexgmbh","https:\/\/www.instagram.com\/inovexlife\/","https:\/\/www.linkedin.com\/company\/inovex","https:\/\/www.youtube.com\/channel\/UC7r66GT14hROB_RQsQBAQUQ"]},{"@type":"Person","@id":"https:\/\/www.inovex.de\/de\/#\/schema\/person\/94bd0e180b2139b0647c4e45414e8799","name":"Eli Mirvic","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/bdea3bf8a303619afe38d1c0af6a35fa73bbac97d273abbeef0b217b63d73f5f?s=96&d=retro&r=g53c3356afde169311a2a2167df167d84","url":"https:\/\/secure.gravatar.com\/avatar\/bdea3bf8a303619afe38d1c0af6a35fa73bbac97d273abbeef0b217b63d73f5f?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bdea3bf8a303619afe38d1c0af6a35fa73bbac97d273abbeef0b217b63d73f5f?s=96&d=retro&r=g","caption":"Eli Mirvic"},"url":"https:\/\/www.inovex.de\/de\/blog\/author\/emirvic\/"}]}},"_links":{"self":[{"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/posts\/14224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/users\/91"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/comments?post=14224"}],"version-history":[{"count":2,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/posts\/14224\/revisions"}],"predecessor-version":[{"id":66520,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/posts\/14224\/revisions\/66520"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/media\/14316"}],"wp:attachment":[{"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/media?parent=14224"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/tags?post=14224"},{"taxonomy":"service","embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/service?post=14224"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/coauthors?post=14224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}