{"id":4181,"date":"2017-02-01T00:00:00","date_gmt":"2017-02-01T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/connecting-power-bi-to-an-azure-analysis-services-server"},"modified":"2025-06-11T06:48:15","modified_gmt":"2025-06-11T13:48:15","slug":"connecting-power-bi-to-an-azure-analysis-services-server","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/","title":{"rendered":"Connecting Power BI to an Azure Analysis Services server"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Last October we released the preview of Azure Analysis Services, which is built on the proven analytics engine in Microsoft SQL Server Analysis Services. With Azure Analysis Services, you can host semantic data models in the cloud. Users in your organization can then connect to your data models using tools like Excel, Power BI, and many others to create reports and perform ad-hoc data analysis.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This blog will focus on everything you need to know to use Power BI Desktop to build reports against an Azure Analysis Services server and deploy that report to PowerBI.com.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before getting started, you&#8217;ll need:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">A data model deployed at an Azure Analysis Services server \u2013 <a href=\"https:\/\/azure.microsoft.com\/blog\/first-azure-as\/\">Creating your first data model in Azure Analysis Services<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Power BI Desktop \u2013 <a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkId=521662&amp;clcid=0x409\">Download the latest version for free<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Power BI Account \u2013 <a href=\"https:\/\/powerbi.microsoft.com\/\">Sign up for Power BI.<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"connect-and-create\">Connect and create<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">1. Open Power BI Desktop<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. Click <b>Get Data<\/b>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp\" alt=\"Power BI Desktop\" title=\"Power BI Desktop\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3. Select <strong>Databases\/SQL Server Analysis Services<\/strong>, and then click connect.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/b06b9ab9-9e88-42cc-93e7-e9301c334671.webp\" alt=\"SQL Server Analysis Services Database\" title=\"SQL Server Analysis Services Database\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">4. Enter your Azure AS server name, and click <b>OK<\/b>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/f5deb673-9ada-46de-8dc6-70998ab97d82.webp\" alt=\"Connect Live Image\" title=\"Connect Live Image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">5. On the <b>Navigator<\/b> screen, select your model, and click <b>OK<\/b>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/955d29ed-0f42-4af3-8ff9-26c79032e535.webp\" alt=\"f3f5300d-3108-4e5b-9134-0eb06ac14d2f\" title=\"f3f5300d-3108-4e5b-9134-0eb06ac14d2f\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You&#8217;ll now see your model displayed in the field list on the side. You can drag and drop the different fields on to your page to build out interactive visuals.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/98c062cd-4c9b-4674-9bb5-032a478d790d.webp\" alt=\"image\" title=\"image\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"publish-to-power-bi\">Publish to Power BI<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Now that you have created your report, you can publish to Power BI. When published, you can view it online and share it with others.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. Save the report locally.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. Click the <strong>Publish<\/strong> button on the <strong>Home<\/strong> tab.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/296f8c52-5e24-4435-8805-1fc6559c762a.webp\" alt=\"image\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If this is your first time publishing, you&#8217;ll be asked to sign in to Power BI.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/ffa7684b-0e83-4838-a951-66d7ed760105.webp\" alt=\"image\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3. Select the destination for your report. This can either be your personal workspace or a group that you are a member of.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4. Once publishing is complete, click the blue link to view the report in Power BI.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/6cc955ca-0bef-4e02-a716-2d51e6fa7791.webp\" alt=\"image\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The report will open in Power BI and will automatically connect to your Azure Analysis Services server.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/29c84b42-42b1-4057-9508-8aacc9a22be8.webp\" alt=\"image\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When connecting from Power BI to Azure Analysis Services, you are connected as your Azure Active Directory identity. This is the same identity as you would have used to sign into Power BI. If you share the report to any other users, you must ensure those users have access to your model.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In addition to the report being published, you&#8217;ll also see a dataset that has been published.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/9ddeae6d-8092-4475-b699-7331d3b3ccc2.webp\" alt=\"image\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You can use this dataset to create new reports against your Azure Analysis Services model directly in Power BI.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Learn more about <a href=\"https:\/\/azure.microsoft.com\/services\/analysis-services\/\">Azure Analysis Services<\/a>.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last October we released the preview of Azure Analysis Services, which is built on the proven analytics engine in Microsoft SQL Server Analysis Services.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1474],"tags":[],"audience":[3054,3057,3053],"content-type":[1511],"product":[1653],"tech-community":[],"topic":[],"coauthors":[995],"class_list":["post-4181","post","type-post","status-publish","format-standard","hentry","category-analytics","audience-business-decision-makers","audience-data-professionals","audience-it-decision-makers","content-type-best-practices","product-azure-analysis-services","review-flag-1680286581-295","review-flag-1-1680286581-825","review-flag-2-1680286581-601","review-flag-3-1680286581-173","review-flag-4-1680286581-250","review-flag-5-1680286581-950","review-flag-free-1680286579-836","review-flag-new-1680286579-546"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Connecting Power BI to an Azure Analysis Services server | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"Last October we released the preview of Azure Analysis Services, which is built on the proven analytics engine in Microsoft SQL Server Analysis Services. With Azure Analysis Services, you can host\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting Power BI to an Azure Analysis Services server | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"Last October we released the preview of Azure Analysis Services, which is built on the proven analytics engine in Microsoft SQL Server Analysis Services. With Azure Analysis Services, you can host\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-01T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T13:48:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp\" \/>\n<meta name=\"author\" content=\"Josh Caplan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Josh Caplan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/josh-caplan\/\",\"@type\":\"Person\",\"@name\":\"Josh Caplan\"}],\"headline\":\"Connecting Power BI to an Azure Analysis Services server\",\"datePublished\":\"2017-02-01T00:00:00+00:00\",\"dateModified\":\"2025-06-11T13:48:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/\"},\"wordCount\":423,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp\",\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/\",\"name\":\"Connecting Power BI to an Azure Analysis Services server | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp\",\"datePublished\":\"2017-02-01T00:00:00+00:00\",\"dateModified\":\"2025-06-11T13:48:15+00:00\",\"description\":\"Last October we released the preview of Azure Analysis Services, which is built on the proven analytics engine in Microsoft SQL Server Analysis Services. With Azure Analysis Services, you can host\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analytics\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Connecting Power BI to an Azure Analysis Services server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connecting Power BI to an Azure Analysis Services server | Microsoft Azure Blog","description":"Last October we released the preview of Azure Analysis Services, which is built on the proven analytics engine in Microsoft SQL Server Analysis Services. With Azure Analysis Services, you can host\u2026","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:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/","og_locale":"en_US","og_type":"article","og_title":"Connecting Power BI to an Azure Analysis Services server | Microsoft Azure Blog","og_description":"Last October we released the preview of Azure Analysis Services, which is built on the proven analytics engine in Microsoft SQL Server Analysis Services. With Azure Analysis Services, you can host\u2026","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2017-02-01T00:00:00+00:00","article_modified_time":"2025-06-11T13:48:15+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp","type":"","width":"","height":""}],"author":"Josh Caplan","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Josh Caplan","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/josh-caplan\/","@type":"Person","@name":"Josh Caplan"}],"headline":"Connecting Power BI to an Azure Analysis Services server","datePublished":"2017-02-01T00:00:00+00:00","dateModified":"2025-06-11T13:48:15+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/"},"wordCount":423,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp","articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/","name":"Connecting Power BI to an Azure Analysis Services server | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp","datePublished":"2017-02-01T00:00:00+00:00","dateModified":"2025-06-11T13:48:15+00:00","description":"Last October we released the preview of Azure Analysis Services, which is built on the proven analytics engine in Microsoft SQL Server Analysis Services. With Azure Analysis Services, you can host\u2026","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/02\/289973d3-e34e-4008-97c0-a9a69921455c.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/connecting-power-bi-to-an-azure-analysis-services-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Analytics","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/"},{"@type":"ListItem","position":3,"name":"Connecting Power BI to an Azure Analysis Services server"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/4181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=4181"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/4181\/revisions"}],"predecessor-version":[{"id":41461,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/4181\/revisions\/41461"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=4181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=4181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=4181"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=4181"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=4181"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=4181"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=4181"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=4181"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=4181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}