{"id":16,"date":"2018-07-04T19:36:53","date_gmt":"2018-07-04T19:36:53","guid":{"rendered":"https:\/\/www.powerbitutorial.org\/?p=16"},"modified":"2018-07-13T16:12:59","modified_gmt":"2018-07-13T16:12:59","slug":"power-bi-sql-server","status":"publish","type":"post","link":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/","title":{"rendered":"Power BI SQL Server"},"content":{"rendered":"<p>In this tutorial, you will learn how Power BI connects to a SQL Server database and how to get data from there. SQL Server databases are one of the most common data sources for Power BI.<br \/>\nThe first step is to open the SQL Server connector. Go to Get Data &gt;&gt; SQL Server.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server.png\" alt=\"\" width=\"641\" height=\"362\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server.png 641w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-300x169.png 300w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-165x92.png 165w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-249x140.png 249w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-232x130.png 232w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-344x193.png 344w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-Database.png\" alt=\"\" width=\"701\" height=\"336\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-Database.png 701w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-Database-300x144.png 300w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/p>\n<p>The next step is to enter the SQL Server name and the database name. In this example, we will be using the AdventurWorks2014 database that can be found here: <a href=\"https:\/\/github.com\/Microsoft\/sql-server-samples\/releases\/tag\/adventureworks\" target=\"_blank\" rel=\"noopener\">https:\/\/github.com\/Microsoft\/sql-server-samples\/releases\/tag\/adventureworks<\/a>. To use this database, you must download a backup version and then restore it into your SQL Server.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-Database.png\" alt=\"\" width=\"701\" height=\"336\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-Database.png 701w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-Database-300x144.png 300w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/p>\n<p>Note that there is another option that appears under Advanced options. Using this option, you have the ability to write a SQL query that will run in your SQL Server database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-Database-Desktop.png\" alt=\"\" width=\"701\" height=\"336\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-Database-Desktop.png 701w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-Database-Desktop-300x144.png 300w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/p>\n<p>We will not be writing any query in this example but just remember that the option is there. Click OK and the connection will be established. The Navigator window will show all Tables, Views and Functions that are in the database:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Navigator.png\" alt=\"\" width=\"881\" height=\"420\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Navigator.png 881w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Navigator-300x143.png 300w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Navigator-768x366.png 768w\" sizes=\"(max-width: 881px) 100vw, 881px\" \/><\/p>\n<p>By scrolling down, you will be able to see all tables and functions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Table-Functions.png\" alt=\"\" width=\"881\" height=\"420\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Table-Functions.png 881w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Table-Functions-300x143.png 300w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Table-Functions-768x366.png 768w\" sizes=\"(max-width: 881px) 100vw, 881px\" \/><\/p>\n<p>From here, you can select a table to preview the items.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Preview.png\" alt=\"\" width=\"1066\" height=\"424\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Preview.png 1066w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Preview-300x119.png 300w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Preview-768x305.png 768w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Preview-1024x407.png 1024w\" sizes=\"(max-width: 1066px) 100vw, 1066px\" \/><\/p>\n<p>Choose the following two tables to load: Sales.SalesOrderDetail and Sales.SalesOrderHeader.<br \/>\nClick Load to load the data in the model.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Load.png\" alt=\"\" width=\"881\" height=\"400\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Load.png 881w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Load-300x136.png 300w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Load-768x349.png 768w\" sizes=\"(max-width: 881px) 100vw, 881px\" \/><\/p>\n<p>To make sure the tables are related as they should be, go to the Relationship menu.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Relationship.png\" alt=\"\" width=\"604\" height=\"538\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Relationship.png 604w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Relationship-300x267.png 300w\" sizes=\"(max-width: 604px) 100vw, 604px\" \/><\/p>\n<p>You will see that that there is a relationship automatically created. To see the relationship, double-click on the Relationship Like and review the tables in the Edit Relationship window. You will see that the tables are related based on the SalesOrderID column:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-27\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-SalesOrderID.png\" alt=\"\" width=\"711\" height=\"593\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-SalesOrderID.png 711w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-SalesOrderID-300x250.png 300w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/p>\n<p>Now you are ready to start and create visualizations. Remember that if you need other data from other tables, you can easily go back and select the tables required. Go to Recent Sources and select the AdventurWorks2014 SQL database.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-AdventurWorks.png\" alt=\"\" width=\"431\" height=\"169\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-AdventurWorks.png 431w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-AdventurWorks-300x118.png 300w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/p>\n<p>Select the Sales.Customer table.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Sales.Customer.Table_.png\" alt=\"\" width=\"881\" height=\"400\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Sales.Customer.Table_.png 881w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Sales.Customer.Table_-300x136.png 300w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-Sales.Customer.Table_-768x349.png 768w\" sizes=\"(max-width: 881px) 100vw, 881px\" \/><\/p>\n<p>And you can see below, this table is related to the previous two:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Tables.png\" alt=\"\" width=\"989\" height=\"417\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Tables.png 989w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Tables-300x126.png 300w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Tables-768x324.png 768w\" sizes=\"(max-width: 989px) 100vw, 989px\" \/><\/p>\n<p>You can now use those customer details for creating visualizations.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31\" src=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Visualizations.png\" alt=\"\" width=\"1081\" height=\"638\" srcset=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Visualizations.png 1081w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Visualizations-300x177.png 300w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Visualizations-768x453.png 768w, https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Visualizations-1024x604.png 1024w\" sizes=\"(max-width: 1081px) 100vw, 1081px\" \/><\/p>\n<p>It\u2019s important to remember that you can go to the source at any time to load more tables necessary for your reports.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, you will learn how Power BI connects to a SQL Server database and how to get data from there. SQL Server databases are one of the most common data sources for Power BI. The first step is to open the SQL Server connector. Go to Get Data &gt;&gt; SQL Server. The next [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":84,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"series":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power BI SQL Server - Power BI Tutorials &amp; How To<\/title>\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.powerbitutorial.org\/tutorials\/power-bi-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI SQL Server - Power BI Tutorials &amp; How To\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, you will learn how Power BI connects to a SQL Server database and how to get data from there. SQL Server databases are one of the most common data sources for Power BI. The first step is to open the SQL Server connector. Go to Get Data &gt;&gt; SQL Server. The next [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Power BI Tutorials &amp; How To\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T19:36:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-07-13T16:12:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1440\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Power BI Tutorials\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Power BI Tutorials\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/\",\"url\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/\",\"name\":\"Power BI SQL Server - Power BI Tutorials &amp; How To\",\"isPartOf\":{\"@id\":\"https:\/\/www.powerbitutorial.org\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-1.png\",\"datePublished\":\"2018-07-04T19:36:53+00:00\",\"dateModified\":\"2018-07-13T16:12:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.powerbitutorial.org\/#\/schema\/person\/67f71ab1cdea5656bf7109e3d515913f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/#primaryimage\",\"url\":\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-1.png\",\"contentUrl\":\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-1.png\",\"width\":2560,\"height\":1440},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.powerbitutorial.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.powerbitutorial.org\/#website\",\"url\":\"https:\/\/www.powerbitutorial.org\/\",\"name\":\"Power BI Tutorials &amp; How To\",\"description\":\"Your leading resource for Microsoft Power BI tutorials\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.powerbitutorial.org\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.powerbitutorial.org\/#\/schema\/person\/67f71ab1cdea5656bf7109e3d515913f\",\"name\":\"Power BI Tutorials\",\"description\":\"Learn how to better use Power BI to accomplish your business objectives.\",\"url\":\"https:\/\/www.powerbitutorial.org\/author\/powerbitutoria\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI SQL Server - Power BI Tutorials &amp; How To","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.powerbitutorial.org\/tutorials\/power-bi-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Power BI SQL Server - Power BI Tutorials &amp; How To","og_description":"In this tutorial, you will learn how Power BI connects to a SQL Server database and how to get data from there. SQL Server databases are one of the most common data sources for Power BI. The first step is to open the SQL Server connector. Go to Get Data &gt;&gt; SQL Server. The next [&hellip;]","og_url":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/","og_site_name":"Power BI Tutorials &amp; How To","article_published_time":"2018-07-04T19:36:53+00:00","article_modified_time":"2018-07-13T16:12:59+00:00","og_image":[{"width":2560,"height":1440,"url":"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-1.png","type":"image\/png"}],"author":"Power BI Tutorials","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Power BI Tutorials","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/","url":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/","name":"Power BI SQL Server - Power BI Tutorials &amp; How To","isPartOf":{"@id":"https:\/\/www.powerbitutorial.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-1.png","datePublished":"2018-07-04T19:36:53+00:00","dateModified":"2018-07-13T16:12:59+00:00","author":{"@id":"https:\/\/www.powerbitutorial.org\/#\/schema\/person\/67f71ab1cdea5656bf7109e3d515913f"},"breadcrumb":{"@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/#primaryimage","url":"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-1.png","contentUrl":"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/07\/Power-BI-SQL-Server-1.png","width":2560,"height":1440},{"@type":"BreadcrumbList","@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.powerbitutorial.org\/"},{"@type":"ListItem","position":2,"name":"Power BI SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.powerbitutorial.org\/#website","url":"https:\/\/www.powerbitutorial.org\/","name":"Power BI Tutorials &amp; How To","description":"Your leading resource for Microsoft Power BI tutorials","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.powerbitutorial.org\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.powerbitutorial.org\/#\/schema\/person\/67f71ab1cdea5656bf7109e3d515913f","name":"Power BI Tutorials","description":"Learn how to better use Power BI to accomplish your business objectives.","url":"https:\/\/www.powerbitutorial.org\/author\/powerbitutoria\/"}]}},"_links":{"self":[{"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/posts\/16"}],"collection":[{"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/comments?post=16"}],"version-history":[{"count":0,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/posts\/16\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/media\/84"}],"wp:attachment":[{"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/media?parent=16"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/categories?post=16"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/tags?post=16"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/series?post=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}