{"id":21095,"date":"2018-07-03T13:59:43","date_gmt":"2018-07-03T11:59:43","guid":{"rendered":"https:\/\/www.inovex.de\/blog\/?p=13194"},"modified":"2022-11-24T10:56:03","modified_gmt":"2022-11-24T09:56:03","slug":"azure-automation-analysis-services","status":"publish","type":"post","link":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/","title":{"rendered":"Azure Analysis Services: How to Automate Your Tabular Model Refresh Using Azure Automation"},"content":{"rendered":"<p>This article shows how to refresh an Analysis Services Tabular Model which is hosted on <a href=\"https:\/\/azure.microsoft.com\/de-de\/services\/analysis-services\/\">Microsoft Azure<\/a> regularly and automatically using Azure automation. A Tabular Model is an in-memory Analysis Services database which can be used by several business intelligence tools for fast and intuitive analysis of data. Tabular models are deployed to a server and subsequently regularly updated with data from various sources. Azure Analysis Services is a platform-as-a-service offering, which means that Microsoft does all the operations work in the background, eg. backups and updates. However it is still in the model administrators&#8216; responsibility to regularly process data. And of course, nobody wants to do this manually all the time. Thus we want to schedule and run processing automatically on Azure. Especially the security part in Azure is a little tricky &#8230;<!--more--><\/p>\n<p>We will do the configuration for regular processing in three steps: First, creating an App Registration in the Azure Portal, then granting permissions for App Registration on Azure Analysis Services and finally creating an Azure Automation Account. So let&#8217;s get started:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 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\/azure-automation-analysis-services\/#Create-an-App-Registration\" >Create an App Registration<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#Obtain\" >Obtain &lt;ApplicationRegistrationName&gt;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#Obtain-2\" >Obtain &lt;ClientID&gt;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#Obtain-3\" >Obtain &lt;Key&gt;<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#Grant-permissions-for-App-Registration-on-Azure-Analysis-Services\" >Grant permissions for App Registration on Azure Analysis Services<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#Schedule-refresh-using-Azure-Automation\" >Schedule refresh using Azure Automation<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#Create-Automation-Account\" >Create Automation Account<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#Add-Modules\" >Add Modules<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#Create-Credentials\" >Create Credentials<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#Create-Runbook\" >Create Runbook<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Create-an-App-Registration\"><\/span>Create an App Registration<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To create an App Registration in the Azure Portal, you need to obtain the following information:\u00a0<em>&lt;ApplicationRegistrationName&gt;, &lt;ClientID&gt;, &lt;Key&gt;<\/em>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Obtain\"><\/span>Obtain &lt;ApplicationRegistrationName&gt;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>First, go to <em>App Registration<\/em> in Azure Portal and click on <em>New application registration.\u00a0<\/em>Before\u00a0creating a new app, ensure you have admin permissions\u00a0for the Azure Active Directory. For the app registration you have to define a <em>Name<\/em> (this is the <em>&lt;ApplicationRegistrationName&gt;<\/em>).\u00a0Choose <em>Application type<\/em> <em>Web app\/API<\/em>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Obtain-2\"><\/span>Obtain &lt;ClientID&gt;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The <em>Sign-on URL <\/em>can be any URL as it doesn\u2019t matter for our purpose.\u00a0\u00a0After creating the Application, make sure to copy and note its ApplicationID (this is &lt;<em>ClientID&gt;<\/em>) as you will need it later.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Obtain-3\"><\/span>Obtain &lt;Key&gt;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To obtain the key, go to <em>Settings -&gt; Keys<\/em> and generate a new key. Ensure you copy and note its value. Now, you should have the proper values for <em>&lt;ApplicationRegistrationName&gt;, &lt;ClientID&gt;<\/em> and <em>&lt;Key&gt;<\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13382\" src=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/06\/SSASModelRefresh2.png\" alt=\"SSASModelRefresh Screenshot\" width=\"521\" height=\"210\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Grant-permissions-for-App-Registration-on-Azure-Analysis-Services\"><\/span>Grant permissions for App Registration on Azure Analysis Services<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After creating the Application Registration, it is now time to grant permissions on Azure Analysis Services. This has to be done via the SQL Server Management Studio (SSMS) as it is not working in the Azure Portal as of today. Ensure you use at least SSMS version 17.3. <img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-13219\" src=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/05\/SQL-Server-Verbindung-herstellen.png\" alt=\"SQL Server Connection Screenshot\" width=\"331\" height=\"219\" \/><\/p>\n<ul>\n<li>Connect to your SSAS Instance via SSMS.<\/li>\n<li>To create a connection with the Server choose <em>Active Directory \u2013 Universal with MFA support<\/em>\u00a0as authentication type.<\/li>\n<\/ul>\n<p>If you are not able to see this option, you probably don\u2019t use the right SSMS version (update!). You are now redirected to the usual Azure authentication.\u00a0Make sure your account is declared as an admin for Azure Analysis Service.<\/p>\n<p>In the next step, open the server properties in SSMS. Then, choose the security settings and click on <em>add<\/em>. Add your your registered application using he search function. If you cannot find your registered application, you will have to add the account manually in the following format:<img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-13368 size-medium\" src=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/06\/Unbenannt-293x300.png\" alt=\"App Registration Property Screenshots\" width=\"293\" height=\"300\" \/><\/p>\n<p><em>app:<em>&lt;ClientID&gt;<\/em>@<em>&lt;tenantid&gt; <\/em><\/em><\/p>\n<p><em>example:<\/em><\/p>\n<p>app:<em>3b4d0ee9-fcf2-41ae-xxxx-xxxxxxxxx<\/em>@<em>539c9603-xxxx-xxxx-xxxx-xxxxxxxxx<\/em><\/p>\n<p>For further information regarding Azure Analysis Services security, please refer to\u00a0<a href=\"https:\/\/docs.microsoft.com\/de-de\/azure\/analysis-services\/analysis-services-addservprinc-admins\" target=\"_blank\" rel=\"noopener\">the official Microsoft documentation<\/a>.<\/p>\n<p>You can find the tenantID in the Azure portal: Go to <em>Azure Active Directory -&gt; Properties -&gt; Directory ID<\/em>. The Directory ID is your tenantID.<\/p>\n<p>Finally, confirm and close everything.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Schedule-refresh-using-Azure-Automation\"><\/span>Schedule refresh using Azure Automation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Create-Automation-Account\"><\/span>Create Automation Account<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-13214\" src=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/05\/image2018-5-7_13-16-1.png\" alt=\"Azure Automation Accounts Screenshot\" width=\"323\" height=\"241\" \/><\/p>\n<p>To create a new Azure Automation Account go to <em>Automation Accounts<\/em> in the Azure Portal. Add a new Azure Automation Account or use an existing one.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Add-Modules\"><\/span>Add Modules<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>With your Automation Account selected go to <em>Modules gallery <\/em>and\u00a0search for the following modules:<\/p>\n<ul>\n<li>Azure.AnalysisServices<\/li>\n<li>SqlServer<\/li>\n<li>AzureRM.profile<\/li>\n<\/ul>\n<p>Add these modules to your Automation Account.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Create-Credentials\"><\/span>Create Credentials<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>After adding the modules, you have to create new Credentials:<\/p>\n<ul>\n<li>Go to <em>Credentials<\/em> and <em>Add a credential<\/em><\/li>\n<li>Define any name, for example <em>SSASModelRefresh<\/em><\/li>\n<li>As the <em>User name<\/em> enter your App Registration\u00a0<em>&lt;ClientID&gt;<\/em><\/li>\n<li>As the <em>Password<\/em> enter your App Registration <em>&lt;Key&gt;<\/em><\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"Create-Runbook\"><\/span>Create Runbook<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Now, we have to create a new <em>Runbook<\/em>:\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-13220\" src=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/05\/image2018-5-7_13-20-51-1.png\" alt=\"Runblock Screenshot\" width=\"347\" height=\"165\" \/><\/p>\n<ul>\n<li>In your Automation Account, go\u00a0to <em>Runbooks<\/em>\u00a0and click on <em>Add a runbook<\/em><\/li>\n<li><em>Create a new runbook <\/em>and choose <em>PowerShell<\/em>\u00a0as Runbook Type<\/li>\n<li>Open the Runbook and click on <em>Edit<\/em><\/li>\n<\/ul>\n<p>Use the following code and fill in the proper values for <em>&lt;TenantID&gt;, &lt;CredentialName&gt;, &lt;SSASServerName&gt;, &lt;SSASDBName&gt;, RolloutEnvironment&gt;<\/em> and <em>&lt;CredentialName&gt;:<\/em><\/p>\n<pre class=\"lang:ps decode:true\"># Get the values stored in the Assets\r\n\r\n$TenantId = \"539c9603-xxxx-xxxx-xxxx-xxxxxxxxxxxx\"\r\n\r\n$Credential = Get-AutomationPSCredential -Name '&lt;CredentialName&gt;'\r\n\r\n$Server = \"asazure:\/\/westeurope.asazure.windows.net\/devassmanalytics\"\r\n\r\n$DatabaseName = \"&lt;SSASDBName&gt;\"\r\n\r\n$RolloutEnvironment = \"westeurope.asazure.windows.net\"\r\n\r\n# Log in to Azure Analysis Services using the Azure AD Service Principal\r\n\r\nAdd-AzureAnalysisServicesAccount -Credential $Credential -ServicePrincipal -TenantId $TenantId -RolloutEnvironment $RolloutEnvironment\r\n\r\n# Perform a Process Full on the Azure Analysis Services database\r\n\r\nInvoke-ProcessASDatabase -Server $Server -DatabaseName $DatabaseName -RefreshType \"Full\"\r\n\r\n<\/pre>\n<p>Afterwards, click on <em>Test pane <\/em>and <em>Start <\/em>to execute your script. If everything is working the Azure Portal should look like this:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-13215\" src=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/05\/image2018-5-7_13-13-25.png\" alt=\"Final Working Azure Portal Screenshot\" width=\"718\" height=\"371\" \/><\/p>\n<p>Your script is running as long as your models needs to be refreshed. You can now publish your <em>Runbook<\/em> and add a schedule via <em>Schedules.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article shows how to refresh an Analysis Services Tabular Model which is hosted on Microsoft Azure regularly and automatically using Azure automation. A Tabular Model is an in-memory Analysis Services database which can be used by several business intelligence tools for fast and intuitive analysis of data. Tabular models are deployed to a server [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":13518,"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":[71],"service":[414],"coauthors":[{"id":74,"display_name":"Sascha G\u00f6tz","user_nicename":"sgoetz"}],"class_list":["post-21095","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-cloud","service-cloud"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Azure Automation: Automate Your Tabular Model Refresh<\/title>\n<meta name=\"description\" content=\"This article shows how to refresh an Analysis Services Tabular Model regularly and automatically using Microsoft Azure Azure Automation.\" \/>\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\/azure-automation-analysis-services\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure Automation: Automate Your Tabular Model Refresh\" \/>\n<meta property=\"og:description\" content=\"This article shows how to refresh an Analysis Services Tabular Model regularly and automatically using Microsoft Azure Azure Automation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inovex.de\/de\/blog\/azure-automation-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-07-03T11:59:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-24T09:56:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/07\/microsoft-azure-automation.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sascha G\u00f6tz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/07\/microsoft-azure-automation-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=\"Sascha G\u00f6tz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\u00a0Minuten\" \/>\n\t<meta name=\"twitter:label3\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data3\" content=\"Sascha G\u00f6tz\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/\"},\"author\":{\"name\":\"Sascha G\u00f6tz\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#\\\/schema\\\/person\\\/ecbba3f5f4f88178c0721e3e46a20e63\"},\"headline\":\"Azure Analysis Services: How to Automate Your Tabular Model Refresh Using Azure Automation\",\"datePublished\":\"2018-07-03T11:59:43+00:00\",\"dateModified\":\"2022-11-24T09:56:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/\"},\"wordCount\":815,\"commentCount\":15,\"publisher\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.inovex.de\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/microsoft-azure-automation.png\",\"keywords\":[\"Cloud\"],\"articleSection\":[\"English Content\",\"General\",\"Infrastructure\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/\",\"url\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/\",\"name\":\"Azure Automation: Automate Your Tabular Model Refresh\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.inovex.de\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/microsoft-azure-automation.png\",\"datePublished\":\"2018-07-03T11:59:43+00:00\",\"dateModified\":\"2022-11-24T09:56:03+00:00\",\"description\":\"This article shows how to refresh an Analysis Services Tabular Model regularly and automatically using Microsoft Azure Azure Automation.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.inovex.de\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/microsoft-azure-automation.png\",\"contentUrl\":\"https:\\\/\\\/www.inovex.de\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/microsoft-azure-automation.png\",\"width\":1280,\"height\":720,\"caption\":\"A cloud with gears, how original!\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/azure-automation-analysis-services\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure Analysis Services: How to Automate Your Tabular Model Refresh Using Azure Automation\"}]},{\"@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\\\/ecbba3f5f4f88178c0721e3e46a20e63\",\"name\":\"Sascha G\u00f6tz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbe65a446ab60300e20b028d0544a302043f5cd6b74669e6579558e24ade7ed4?s=96&d=retro&r=gd748e895a37174c723f01ce045293bf0\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbe65a446ab60300e20b028d0544a302043f5cd6b74669e6579558e24ade7ed4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbe65a446ab60300e20b028d0544a302043f5cd6b74669e6579558e24ade7ed4?s=96&d=retro&r=g\",\"caption\":\"Sascha G\u00f6tz\"},\"url\":\"https:\\\/\\\/www.inovex.de\\\/de\\\/blog\\\/author\\\/sgoetz\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure Automation: Automate Your Tabular Model Refresh","description":"This article shows how to refresh an Analysis Services Tabular Model regularly and automatically using Microsoft Azure Azure Automation.","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\/azure-automation-analysis-services\/","og_locale":"de_DE","og_type":"article","og_title":"Azure Automation: Automate Your Tabular Model Refresh","og_description":"This article shows how to refresh an Analysis Services Tabular Model regularly and automatically using Microsoft Azure Azure Automation.","og_url":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/","og_site_name":"inovex GmbH","article_publisher":"https:\/\/www.facebook.com\/inovexde","article_published_time":"2018-07-03T11:59:43+00:00","article_modified_time":"2022-11-24T09:56:03+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/07\/microsoft-azure-automation.png","type":"image\/png"}],"author":"Sascha G\u00f6tz","twitter_card":"summary_large_image","twitter_image":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/07\/microsoft-azure-automation-1024x576.png","twitter_creator":"@inovexgmbh","twitter_site":"@inovexgmbh","twitter_misc":{"Verfasst von":"Sascha G\u00f6tz","Gesch\u00e4tzte Lesezeit":"4\u00a0Minuten","Written by":"Sascha G\u00f6tz"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#article","isPartOf":{"@id":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/"},"author":{"name":"Sascha G\u00f6tz","@id":"https:\/\/www.inovex.de\/de\/#\/schema\/person\/ecbba3f5f4f88178c0721e3e46a20e63"},"headline":"Azure Analysis Services: How to Automate Your Tabular Model Refresh Using Azure Automation","datePublished":"2018-07-03T11:59:43+00:00","dateModified":"2022-11-24T09:56:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/"},"wordCount":815,"commentCount":15,"publisher":{"@id":"https:\/\/www.inovex.de\/de\/#organization"},"image":{"@id":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/07\/microsoft-azure-automation.png","keywords":["Cloud"],"articleSection":["English Content","General","Infrastructure"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/","url":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/","name":"Azure Automation: Automate Your Tabular Model Refresh","isPartOf":{"@id":"https:\/\/www.inovex.de\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#primaryimage"},"image":{"@id":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/07\/microsoft-azure-automation.png","datePublished":"2018-07-03T11:59:43+00:00","dateModified":"2022-11-24T09:56:03+00:00","description":"This article shows how to refresh an Analysis Services Tabular Model regularly and automatically using Microsoft Azure Azure Automation.","breadcrumb":{"@id":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#primaryimage","url":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/07\/microsoft-azure-automation.png","contentUrl":"https:\/\/www.inovex.de\/wp-content\/uploads\/2018\/07\/microsoft-azure-automation.png","width":1280,"height":720,"caption":"A cloud with gears, how original!"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inovex.de\/de\/blog\/azure-automation-analysis-services\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inovex.de\/de\/"},{"@type":"ListItem","position":2,"name":"Azure Analysis Services: How to Automate Your Tabular Model Refresh Using Azure Automation"}]},{"@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\/ecbba3f5f4f88178c0721e3e46a20e63","name":"Sascha G\u00f6tz","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/cbe65a446ab60300e20b028d0544a302043f5cd6b74669e6579558e24ade7ed4?s=96&d=retro&r=gd748e895a37174c723f01ce045293bf0","url":"https:\/\/secure.gravatar.com\/avatar\/cbe65a446ab60300e20b028d0544a302043f5cd6b74669e6579558e24ade7ed4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cbe65a446ab60300e20b028d0544a302043f5cd6b74669e6579558e24ade7ed4?s=96&d=retro&r=g","caption":"Sascha G\u00f6tz"},"url":"https:\/\/www.inovex.de\/de\/blog\/author\/sgoetz\/"}]}},"_links":{"self":[{"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/posts\/21095","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\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/comments?post=21095"}],"version-history":[{"count":1,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/posts\/21095\/revisions"}],"predecessor-version":[{"id":39564,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/posts\/21095\/revisions\/39564"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/media\/13518"}],"wp:attachment":[{"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/media?parent=21095"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/tags?post=21095"},{"taxonomy":"service","embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/service?post=21095"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.inovex.de\/de\/wp-json\/wp\/v2\/coauthors?post=21095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}