{"id":43861,"date":"2024-11-18T22:31:36","date_gmt":"2024-11-18T17:31:36","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=43861"},"modified":"2026-01-19T16:21:00","modified_gmt":"2026-01-19T11:21:00","slug":"power-bi-data-marts","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/power-bi-data-marts","title":{"rendered":"Power BI Data Marts: A Comprehensive Guide"},"content":{"rendered":"<p>Power BI Data mart is a new feature that helps in efficient data visualization. Microsoft introduced it, and it&#8217;s still in the preview stage. The Power BI Data mart is a self-service analytic solution that helps users store and explore data loaded in a fully managed database. It eliminates the need for database administration.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/power-bi-data-marts.jpg\" alt=\"Power BI Data Marts\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk2ODMrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTY4Mys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTY4Mys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>In this blog, you\u2019ll discover what the Power BI Data mart is, why it is important, how to create a Data mart in Power BI, and how to use it.<\/p>\n<h3>Table of Contents:<\/h3>\n<ol>\n<li><a href=\"#what-is-a-data-mart-in-power-bi\">What is a Data Mart in Power BI?<\/a><\/li>\n<li><a href=\"#why-is-power-bi-data-marts-important\">Why are Power BI Data Marts Important?<\/a><\/li>\n<li><a href=\"#how-to-create-data-mart-in-power-bi\">How to Create a Data Mart in Power BI?<\/a><\/li>\n<li><a href=\"#how-to-visualize-data-in-power-bi\">How to Visualize Data Marts in Power BI?<\/a><\/li>\n<li><a href=\"#what-are-the-benefits-of-power-bi-data-marts\">What are the Benefits of Power BI Data Marts?<\/a><\/li>\n<li><a href=\"#what-are-the-best-practices-for-data-mart-in-power-bi\">What are the Best Practices for a data mart in Power BI?<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<p>First&#8230;<\/p>\n<h2 id=\"what-is-a-data-mart-in-power-bi\">What is a Data Mart in Power BI?<\/h2>\n<p>Power BI Data Mart enables users to build, load, transform, and upload data to <a href=\"https:\/\/chartexpo.com\/blog\/cloud-based-data-warehouse\" target=\"_blank\" rel=\"noopener\">data warehouses<\/a> and create datasets. It also allows users to create secure and governed databases from various data sources with no coding experience.<\/p>\n<p>Users can create compelling <a href=\"https:\/\/chartexpo.com\/blog\/data-visualization-guide\" target=\"_blank\" rel=\"noopener\">data visualizations<\/a>, build relationships, store, query, retrieve, and refresh data from multiple data sources.<\/p>\n<h2 id=\"why-is-power-bi-data-marts-important\">Why are Power BI Data Marts Important?<\/h2>\n<p>Benefits of using Power BI Data marts:<\/p>\n<ul>\n<li>DAX measures in Data marts<\/li>\n<li>Connection with SQL endpoint outside Power BI<\/li>\n<li>Data marts are comprised of an SQL endpoint, which allows users to connect to this endpoint from other tools<\/li>\n<li>User-friendly<\/li>\n<li>No-code experience is required for data ingestion, preparation, and transformation.<\/li>\n<\/ul>\n<p>Data mart features:<\/p>\n<ul>\n<li>Automated performance tuning<\/li>\n<li>A no-code experience that results in a fully managed Data mart<\/li>\n<li>100% web-based, no other software required<\/li>\n<li>Support for SQL and other popular client tools<\/li>\n<li>Included with <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-pro-vs-premium\" target=\"_blank\" rel=\"noopener\">Power BI Premium<\/a> capacities and Premium Per User.<\/li>\n<\/ul>\n<h2 id=\"how-to-create-data-mart-in-power-bi\">How to Create a Data Mart in Power BI?<\/h2>\n<p>You\u2019ll have to navigate to your existing Power BI Premium or Premium Per User (PPU) workspace. However, you\u2019ll need to have a Power BI Premium subscription. Once in the Premium workspace, select + New. After that, select \u201cData mart (Preview)\u201d to create a Data mart.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-new-after-that-select-data-mart-to-create-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-new-after-that-select-data-mart-to-create-power-bi-data-marts.jpg\" alt=\"Select + New After that Select Data mart to Create Power BI Data Marts\" width=\"397\" \/><\/a><\/div>\n<p>To load data into the Data mart, open your Data mart (or create a new Data mart). After that, select \u201cGet Data.\u201d<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-get-data-to-create-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-get-data-to-create-power-bi-data-marts.jpg\" alt=\"Select Get Data to Create Power BI Data Marts\" width=\"465\" \/><\/a><\/div>\n<p>If you opt to get data from a different source, you can do that by selecting your preferred data source from the multitude of data sources in the data source selection window that appears on your screen.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/data-source-selection-appears-on-screen-to-create-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/data-source-selection-appears-on-screen-to-create-power-bi-data-marts.jpg\" alt=\"Data Source Selection Appears on Screen to Create Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<p>There\u2019s the option of dragging and dropping files from your computer to load data into your data mart. These files could be Excel files. There are cases where data sources require parameters (or connection strings) to properly connect.<\/p>\n<p>After the connection, select the tables you want to load into the data mart. You can apply transformations to your chosen data and load the data into the data mart. After loading the data, the tables are imported into your data mart. At this point, you\u2019ll have to monitor the progress in the status bar.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/monitor-progress-in-status-bar-to-create-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/monitor-progress-in-status-bar-to-create-power-bi-data-marts.jpg\" alt=\"Monitor Progress in Status Bar to Create Power BI Data Marts\" width=\"540\" \/><\/a><\/div>\n<p>For each selected table, a corresponding view is created in the data mart, and it appears in the \u201cObject Explorer\u201d in \u201cData View.\u201d<\/p>\n<p>To model your data, navigate to &#8220;Model view.&#8221; That can be done by selecting the &#8220;Model View&#8221; icon found at the bottom of the window, as shown in the image below.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-model-view-icon-to-create-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-model-view-icon-to-create-power-bi-data-marts.jpg\" alt=\"Select Model View Icon to Create Power BI Data Marts\" width=\"440\" \/><\/a><\/div>\n<div>Check out the <a href=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiOTEzZTdjZGUtNzE5MS00ODk2LWJkOTAtNTI3ZjMwNWI1MTdhIiwidCI6IjYyZmVhOGJlLTZlNzQtNDMyNC1hZjhjLTIyNjgzMjI2MmJjYiIsImMiOjF9\" target=\"_blank\" rel=\"noopener nofollow\">Sankey Diagram for Power BI<\/a> demo by ChartExpo here:<\/div>\n<h2 id=\"how-to-visualize-data-in-power-bi\">How to Visualize Data Marts in Power BI?<\/h2>\n<p data-pm-slice=\"0 0 []\">Use <a href=\"https:\/\/chartexpo.com\/tools\/power-bi-custom-visuals\" target=\"_blank\" rel=\"noopener\">Power BI charts<\/a> to connect, summarize, and visualize data marts in one view, making patterns, relationships, and insights easy to explore and share.<\/p>\n<h3>Stage 1: Log in to Power BI, enter your email, and click \u201cSubmit.\u201d<\/h3>\n<ul>\n<li>Log in to Power BI.<\/li>\n<li>Enter your email address and click the \u201c<strong>Submit<\/strong>\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\" alt=\"Enter email to login to Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You are redirected to your Microsoft account.<\/li>\n<li>Enter your password and click \u201c<strong>Sign in<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\" alt=\"Enter Password to login to Power BI\" width=\"363\" \/><\/a><\/div>\n<ul>\n<li>You can choose whether to stay signed in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\" alt=\"Click on stay signed in\" width=\"392\" \/><\/a><\/div>\n<ul>\n<li>Once done, the Power BI home screen will open.<\/li>\n<\/ul>\n<h3>Stage 2: Create a Data Set and Select the Data Set to Use in the Sankey Chart<\/h3>\n<ul>\n<li>Go to the left-side menu and click the \u201c<strong>Create<\/strong>\u201d button.<\/li>\n<li>Select \u201c<strong>Paste or manually enter data<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce487.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce487.jpg\" alt=\"select Paste or manually enter data in Power BI ce487\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk2ODMrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTY4Mys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTY4Mys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<ul>\n<li>We&#8217;ll use the <a href=\"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi\" target=\"_blank\" rel=\"noopener noreferrer\">sample data<\/a> below for this example.<\/li>\n<\/ul>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td><strong>Application Channels<\/strong><\/td>\n<td><strong>Initial Screening<\/strong><\/td>\n<td><strong>Conduct Interviews<\/strong><\/td>\n<td><strong>Employee Onboarding<\/strong><\/td>\n<td>\n<div>\n<div><strong>Total Candidates<\/strong><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td>Social Media<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>32<\/td>\n<\/tr>\n<tr>\n<td>Social Media<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>400<\/td>\n<\/tr>\n<tr>\n<td>Social Media<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>800<\/td>\n<\/tr>\n<tr>\n<td>Social Media<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>1100<\/td>\n<\/tr>\n<tr>\n<td>Company Career Page<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>20<\/td>\n<\/tr>\n<tr>\n<td>Company Career Page<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>250<\/td>\n<\/tr>\n<tr>\n<td>Company Career Page<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>500<\/td>\n<\/tr>\n<tr>\n<td>Company Career Page<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>900<\/td>\n<\/tr>\n<tr>\n<td>Events<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>5<\/td>\n<\/tr>\n<tr>\n<td>Events<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>100<\/td>\n<\/tr>\n<tr>\n<td>Events<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>200<\/td>\n<\/tr>\n<tr>\n<td>Events<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>350<\/td>\n<\/tr>\n<tr>\n<td>Paper Media<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>3<\/td>\n<\/tr>\n<tr>\n<td>Paper Media<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>80<\/td>\n<\/tr>\n<tr>\n<td>Paper Media<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>135<\/td>\n<\/tr>\n<tr>\n<td>Paper Media<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>700<\/td>\n<\/tr>\n<tr>\n<td>Employee Referrals<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td>Employee Referrals<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>70<\/td>\n<\/tr>\n<tr>\n<td>Employee Referrals<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>80<\/td>\n<\/tr>\n<tr>\n<td>Employee Referrals<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>110<\/td>\n<\/tr>\n<tr>\n<td>Direct<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>25<\/td>\n<\/tr>\n<tr>\n<td>Direct<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>150<\/td>\n<\/tr>\n<tr>\n<td>Direct<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>425<\/td>\n<\/tr>\n<tr>\n<td>Direct<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>600<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>Paste the data table above into the \u201cPower Query\u201d window. After that, select the \u201cCreate a dataset only\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-create-a-dataset-only-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-create-a-dataset-only-after-creating-power-bi-data-marts.jpg\" alt=\"Select Create a Dataset Only After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Navigate to the left-side menu, and click on the &#8220;Data Hub&#8217; option. Power BI will populate the data set list. If no data set has been created, you&#8217;ll get an error message.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/click-on-data-hub-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/click-on-data-hub-after-creating-power-bi-data-marts.jpg\" alt=\"Click on Data Hub After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on the \u201cCreate report\u201d dropdown.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/click-create-report-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/click-create-report-after-creating-power-bi-data-marts.jpg\" alt=\"Click Create Report After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To add the Power BI Sankey Diagram Extension by ChartExpo, you\u2019ll need an add-in or Power BI visual from AppSource. Next, navigate to the right side of the Power BI dashboard, and open the Power BI Visualizations panel. Click the ellipsis symbol (\u2026) to import the Power BI Sankey Diagram extension by ChartExpo. In the following menu that opens, select the \u201cGet more visuals\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-get-more-visuals-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-get-more-visuals-after-creating-power-bi-data-marts.jpg\" alt=\"Select Get More Visuals After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>In the window that opens, enter \u201cChartExpo&#8221; in the highlighted search box. You&#8217;ll see the &#8220;Sankey Diagram for Power BI by ChartExpo.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/enter-sankey-diagram-in-search-box-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/enter-sankey-diagram-in-search-box-after-creating-power-bi-data-marts.jpg\" alt=\"Enter Sankey Diagram in Search Box After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on the <a href=\"https:\/\/www.chartexpo.com\/charts\/sankey-diagram\" target=\"_blank\" rel=\"noopener\">Sankey plot<\/a>. Next, click the highlighted &#8220;Add&#8221; button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/click-on-add-button-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/click-on-add-button-after-creating-power-bi-data-marts.jpg\" alt=\"Click on Add Button After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>The \u201cSankey Diagram for Power BI by ChartExpo\u201d icon will be added by Power BI in the visualization panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/sankey-diagram-icon-will-be-added-in-visualization-panel-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/sankey-diagram-icon-will-be-added-in-visualization-panel-after-creating-power-bi-data-marts.jpg\" alt=\"Sankey Diagram Icon will be Added in Visualization Panel After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To draw a Sankey Diagram with ChartExpo\u2019s Power BI extension, select the \u201cSankey Diagram for Power BI by ChartExpo\u201d icon in the visualization panel. A window similar to the one below will be displayed in the report section of your dashboard.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/report-section-of-dashboard-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/report-section-of-dashboard-after-creating-power-bi-data-marts.jpg\" alt=\"Report Section of Dashboard After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Select the fields to use in the Sankey chart.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-fields-to-use-in-sankey-chart-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/select-fields-to-use-in-sankey-chart-after-creating-power-bi-data-marts.jpg\" alt=\"Select Fields to Use in Sankey Chart After Creating Power BI Data Marts\" width=\"231\" \/><\/a><\/div>\n<ul>\n<li>Follow the sequence below when selecting the fields:<\/li>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Application Channels<\/li>\n<li>Initial Screening<\/li>\n<li>Conduct Interviews<\/li>\n<li>Employee Onboarding<\/li>\n<li>Total Candidates<\/li>\n<\/ul>\n<\/li>\n<li>You\u2019ll have to provide your email address or a ChartExpo license key. To see the Sankey Chart, add the key under the visual section.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/provide-license-key-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/provide-license-key-after-creating-power-bi-data-marts.jpg\" alt=\"Provide License Key After Creating Power BI Data Marts\" width=\"228\" \/><\/a><\/div>\n<ul>\n<li>You can add the top header text in the chart under the General section as shown below:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/add-top-header-text-in-chart-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/add-top-header-text-in-chart-after-creating-power-bi-data-marts.jpg\" alt=\"Add Top Header Text in Chart After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>After that, click on Visual to set the number and also enable the options.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/click-on-visual-to-set-number-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/click-on-visual-to-set-number-after-creating-power-bi-data-marts.jpg\" alt=\"Click on Visual to Set Number After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can change the \u201cNode Font Style.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/change-node-font-style-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/change-node-font-style-after-creating-power-bi-data-marts.jpg\" alt=\"Change Node Font Style After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can also change the &#8220;Level Font Style.&#8221;<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/change-level-font-style-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/change-level-font-style-after-creating-power-bi-data-marts.jpg\" alt=\"Change Level Font Style After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Here&#8217;s what the Level Labels look like.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/level-labels-look-like-below-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/level-labels-look-like-below-after-creating-power-bi-data-marts.jpg\" alt=\"Level Labels Look Like Below After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can change the Nodes color by following the step(s) below:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/change-nodes-color-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/change-nodes-color-after-creating-power-bi-data-marts.jpg\" alt=\"Change Nodes Color After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Since you\u2019ve seen \u201cHow to change Level 1 color,\u201d follow the same steps to change the Nodes color of other levels.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/change-nodes-color-of-other-levels-after-creating-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/change-nodes-color-of-other-levels-after-creating-power-bi-data-marts.jpg\" alt=\"Change Nodes Color of Other Levels After Creating Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>After changing the color of all the nodes, the final look of the HR Dashboard in Power BI using ChartExpo will be similar to the image below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/final-power-bi-data-marts.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/final-power-bi-data-marts.jpg\" alt=\"Final Power BI Data Marts\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk2ODMrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTY4Mys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTY4Mys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h4>Insights<\/h4>\n<ul>\n<li>Social Media is the primary application with the highest number of candidates (1100).<\/li>\n<li>Company Career Page follows with 900 candidates.<\/li>\n<li>Paper Media and Events have comparatively lower candidate counts of 700 and 350, respectively.<\/li>\n<li>Direct applications have 600 candidates.<\/li>\n<\/ul>\n<p><em>Read here<\/em> about <span data-sheets-root=\"1\"><a href=\"https:\/\/chartexpo.com\/blog\/conditional-formatting-in-power-bi\" target=\"_blank\" rel=\"noopener\">conditional formatting in Power BI<\/a>:<\/span><\/p>\n<h3>Streamline Reporting with Powerful Graphs in Power BI Data Marts:<\/h3>\n<p>Unlock the power of Power BI Data Marts with this hands-on tutorial, where you&#8217;ll learn how to create and visualize centralized data repositories for efficient reporting and analysis. Data Marts in Power BI allow you to streamline your data sources into focused, easily accessible segments, enhancing the clarity of your visuals. With dynamic charts and graphs, including the <a href=\"https:\/\/chartexpo.com\/blog\/sankey-diagram-in-power-bi\" target=\"_blank\" rel=\"noopener\">Sankey Diagram in Power BI<\/a>, you can quickly spot trends, compare data points, and gain deeper insights into business operations. By organizing your data into specific categories, Power BI Data Marts help you present a more structured and visually impactful view of your organization&#8217;s key metrics.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/_UyS9hzktr8?si=zkl8vEiizt8_NipC\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe><\/p>\n<h2 id=\"what-are-the-benefits-of-power-bi-data-marts\">What are the Benefits of Power BI Data Marts?<\/h2>\n<p>Power BI Data Marts are a powerful tool designed to simplify and enhance <a href=\"https:\/\/chartexpo.com\/blog\/data-analysis\" target=\"_blank\" rel=\"noopener\">data analysis<\/a> within organizations. Here are the key benefits of using them:<\/p>\n<ul>\n<li>\n<h3>Self-Service Data Management<\/h3>\n<\/li>\n<\/ul>\n<p>With the Power BI Data mart, non-technical users like business analysts can create, manage, and explore data without deep database or coding expertise.<\/p>\n<ul>\n<li>\n<h3>Integrated Data Platform<\/h3>\n<\/li>\n<\/ul>\n<p>Data mart enables users to integrate multiple data sources (like on-premises, cloud, databases, and Excel) into one structured relational format. Data is stored in a centralized location, and that provides a unified source of truth for analysis and reporting.<\/p>\n<ul>\n<li>\n<h3>Scalable Data Storage<\/h3>\n<\/li>\n<\/ul>\n<p>Data mart is built to handle and scale with medium to <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-dataset\" target=\"_blank\" rel=\"noopener\">Power BI datasets<\/a>, and that allows for efficient storage and querying of complex data models.<\/p>\n<ul>\n<li>\n<h3>SQL Querying Support<\/h3>\n<\/li>\n<\/ul>\n<p>With Data mart, users can write SQL queries to explore and retrieve data. This provides flexibility for those familiar with SQL.<\/p>\n<h2 id=\"what-are-the-best-practices-for-data-mart-in-power-bi\">What are the Best Practices for Data mart in Power BI?<\/h2>\n<p>Power BI Data Marts enable efficient data storage, transformation, and analysis. To maximize their effectiveness, follow these best practices:<\/p>\n<ul>\n<li>\n<h3>Data Modeling Best Practices<\/h3>\n<\/li>\n<\/ul>\n<p>Your Data mart should be structured using a star schema. The fact tables (transactional data) should be connected to dimension tables (reference data). This simplifies query performance and improves report creation.<\/p>\n<ul>\n<li>\n<h3>Data Cleansing and Transformation<\/h3>\n<\/li>\n<\/ul>\n<p>Power Query can be used to clean and transform your data. That involves <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-remove-duplicates\" target=\"_blank\" rel=\"noopener\">removing duplicates<\/a>, handling missing data, and formatting columns before loading them into the data mart. You should also filter out irrelevant records or columns, and load only necessary data.<\/p>\n<ul>\n<li>\n<h3>Efficient ETL (Extract, Transform, Load)<\/h3>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/chartexpo.com\/blog\/power-bi-vs-power-query\" target=\"_blank\" rel=\"noopener\">Power Query<\/a> is used to efficiently shape data. Always apply transformations in a logical order. It could involve filtering rows early in the query to reduce the dataset size before applying more complex operations.<\/p>\n<ul>\n<li>\n<h3>Performance Optimization<\/h3>\n<\/li>\n<\/ul>\n<p>SQL performance tuning techniques should be used within the Data mart to optimize query execution. Also, review <a href=\"https:\/\/chartexpo.com\/blog\/connecting-power-bi-to-sql-server\" target=\"_blank\" rel=\"noopener\">SQL query<\/a> plans to identify slow-performing queries. You can improve query performance and load times by partitioning large tables in the data mart.<\/p>\n<h2>FAQs<\/h2>\n<h3>What are the limitations of Data mart in Power BI?<\/h3>\n<p>Power BI comes with limitations like complexity in data transformations, data size constraints, limited direct integration with some data sources, lack of advanced modeling features, and potential performance issues with large datasets.<\/p>\n<h3>How do I connect Power BI to Data mart?<\/h3>\n<p>To connect Power BI to a Data mart, use Power BI Desktop (or Service). Next, select \u201cGet Data,\u201d choose \u201cPower BI Data mart,\u201d and connect using the Data mart URL and credentials.<\/p>\n<h3>How does Power BI Data mart support data analysis?<\/h3>\n<p>Power BI Data mart supports data analysis by centralizing and structuring data. It gives room for self-service data exploration, enables SQL querying, integrates with Power BI for visualizations, and provides performance optimization.<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Power BI Data mart is a specialized data repository for analyzing and storing structured data. It centralizes data, enables efficient queries, and supports self-service analytics.<\/p>\n<p>Data mart supports SQL and other popular client tools. It can integrate with Power BI, Microsoft Office, and other Microsoft analytics offerings.<\/p>\n<p>The Power BI Data mart is optimized for large datasets. It\u2019s built to handle and scale with medium to large datasets, and that allows for efficient storage and querying of complex data models.<\/p>\n<p>With Power Query, users are enabled to perform Extract, Transform, and Load (ETL) processes, which helps clean and shape data as it&#8217;s loaded into the data mart.<\/p>\n<p>Finally, the Power BI Data mart is a feature that helps in the overall creation of compelling visualizations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Power BI Data Marts streamline data workflows with no-code solutions. Learn how to create, transform, and query data for optimized reporting &#038; better insights.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/power-bi-data-marts\"><\/a><\/p>","protected":false},"author":1,"featured_media":43867,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1017],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Power BI Data Marts: A Comprehensive Guide -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/power-bi-data-marts\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"Power BI Data Marts: A Comprehensive Guide -\" \/>\r\n<meta name=\"twitter:description\" content=\"Power BI Data Marts streamline data workflows with no-code solutions. Learn how to create, transform, and query data for optimized reporting &amp; better insights.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/feature-ce683-200x200-1.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI Data Marts: A Comprehensive Guide -","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:\/\/chartexpo.com\/blog\/power-bi-data-marts","twitter_card":"summary_large_image","twitter_title":"Power BI Data Marts: A Comprehensive Guide -","twitter_description":"Power BI Data Marts streamline data workflows with no-code solutions. Learn how to create, transform, and query data for optimized reporting & better insights.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/11\/feature-ce683-200x200-1.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/power-bi-data-marts","url":"https:\/\/chartexpo.com\/blog\/power-bi-data-marts","name":"Power BI Data Marts: A Comprehensive Guide -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2024-11-18T17:31:36+00:00","dateModified":"2026-01-19T11:21:00+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/power-bi-data-marts#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/power-bi-data-marts"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/power-bi-data-marts#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"Power BI Data Marts: A Comprehensive Guide"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/43861"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=43861"}],"version-history":[{"count":12,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/43861\/revisions"}],"predecessor-version":[{"id":58049,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/43861\/revisions\/58049"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/43867"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=43861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=43861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=43861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}