{"id":39731,"date":"2024-09-06T20:19:55","date_gmt":"2024-09-06T15:19:55","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=39731"},"modified":"2025-11-13T13:36:16","modified_gmt":"2025-11-13T08:36:16","slug":"power-bi-and-aws","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/power-bi-and-aws","title":{"rendered":"Power BI and AWS Integration for Better Data Insights"},"content":{"rendered":"<p>AWS products and services are known for efficiently storing data. They&#8217;re also cost-effective, secure, and reliable. That&#8217;s why business owners of all sizes use them to store their data.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/power-bi-and-aws.jpg\" alt=\"Power BI and AWS\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk2MzIrU2Fua2V5Kw==\" 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\/MTYrYmxvZytncytjZXhwbytDRTYzMis=\" 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\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTYzMis=\" 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>However, not everyone knows what Power BI and AWS entail. In this guide, you&#8217;ll discover all there is to know about Power BI and AWS, requirements for Power BI on AWS, and how to install and configure Microsoft Power BI to AWS data sources.<\/p>\n<h3>Table of Contents:<\/h3>\n<ol>\n<li><a href=\"#what-is-power-bi-aws\">What is Power BI AWS?<\/a><\/li>\n<li><a href=\"#what-are-the-requirements-for-power-bi-on-aws\">What are the Requirements for Power BI on AWS?<\/a><\/li>\n<li><a href=\"#how-to-install-and-configure-microsoft-power-bi-to-aws-data-sources\">How to Install and Configure Microsoft Power BI to AWS Data Sources?<\/a><\/li>\n<li><a href=\"#how-to-create-visualizations-in-power-bi\">How to Visualize AWS Integration Data in Power BI?<\/a><\/li>\n<li><a href=\"#what-are-the-benefits-of-power-bi-integration-with-aws\">What are the Benefits of Power BI Integration with AWS?<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<p>First&#8230;<\/p>\n<h2 id=\"what-is-power-bi-aws\">What is Power BI AWS?<\/h2>\n<p>Power BI AWS involves the integration of Microsoft Power BI with Amazon Web Services (AWS). Microsoft Power BI is a <a href=\"https:\/\/chartexpo.com\/blog\/business-analytics\" target=\"_blank\" rel=\"noopener noreferrer\">business analytics<\/a> service by Microsoft, while the Amazon Web Service is a comprehensive cloud computing platform offered by Amazon.<\/p>\n<p>The integration helps users to take advantage of the powerful <a href=\"https:\/\/chartexpo.com\/blog\/data-visualization-guide\" target=\"_blank\" rel=\"noopener noreferrer\">data visualization<\/a> and reporting capabilities of Power BI, and also utilize the AWS infrastructure for data processing, management, and storage.<\/p>\n<h2 id=\"what-are-the-requirements-for-power-bi-on-aws\">What are the Requirements for Power BI on AWS?<\/h2>\n<h3>Power BI Requirements<\/h3>\n<ul>\n<li>Power BI Desktop: You need to install the tool on your Windows machine.<\/li>\n<li>Power BI Service: You should have a <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-pro-vs-premium\" target=\"_blank\" rel=\"noopener noreferrer\">Power BI Pro or Premium<\/a> account to share and publish reports.<\/li>\n<li>Gateway: The on-premises <a href=\"https:\/\/chartexpo.com\/blog\/data-gateway-in-power-bi\" target=\"_blank\" rel=\"noopener noreferrer\">data gateway<\/a> is needed for users who need to connect to on-premises data sources.<\/li>\n<\/ul>\n<h3>AWS Requirements<\/h3>\n<p>You&#8217;ll need an AWS account with access to the required services. These include:<\/p>\n<ul>\n<li>Data Storage Services: Like the Amazon S3, Amazon RDS, and Amazon Redshift.<\/li>\n<li>Data Processing Services (if necessary): Like the AWS Lambda, AWS Glue, and Amazon EMR.<\/li>\n<li>Networking and Security: Like the VPC (Virtual Private Cloud), IAM (Identity and Access Management), Security Groups, and ACLs.<\/li>\n<\/ul>\n<h3>Configuration Steps<\/h3>\n<p><strong>Set Up AWS Data Sources<\/strong><\/p>\n<ul>\n<li>Create and configure data storage solutions like RDS, Redshift, and Amazon S3.<\/li>\n<li>Populate the data sources with the necessary data.<\/li>\n<\/ul>\n<p><strong>Networking and Security Configuration<\/strong><\/p>\n<ul>\n<li>Set up the IAM roles and policies. This will enable the Power BI to access AWS data sources.<\/li>\n<li>Configure security groups, VPC, and network ACLs as required.<\/li>\n<\/ul>\n<p><strong>Power BI Configuration<\/strong><\/p>\n<ul>\n<li>With the <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-connectors\" target=\"_blank\" rel=\"noopener noreferrer\">built-in connectors<\/a>, connect the Power BI Desktop to the AWS data sources like Amazon S3, Amazon RDS, and Amazon Redshift.<\/li>\n<li>Transform and model the data using Power BI&#8217;s Power Query.<\/li>\n<li>Create the necessary dashboards and reports.<\/li>\n<li>Publish the reports to the Power BI Service for easy collaboration and sharing.<\/li>\n<\/ul>\n<h3>Best Practices<\/h3>\n<ul>\n<li>Security: Implement comprehensive security practices that include encryption of data at rest and in transit.<\/li>\n<li>Cost Management: Manage and monitor AWS usage to control costs.<\/li>\n<li>Scaling: Always plan for scalability, especially if you&#8217;re handling large datasets or a high number of users.<\/li>\n<\/ul>\n<h2 id=\"how-to-install-and-configure-microsoft-power-bi-to-aws-data-sources\">How to Install and Configure Microsoft Power BI to AWS Data Sources?<\/h2>\n<h3>Install Microsoft Power BI<\/h3>\n<p>To download Power BI Desktop, navigate to the Power BI website, and download and install Power BI Desktop.<\/p>\n<p>Installing the Power BI Desktop is simple. Follow the installation instructions you&#8217;ll see on the download page. After installation, launch the Power BI Desktop.<\/p>\n<h3>Configure AWS Data Sources<\/h3>\n<p>You can connect Power BI to multiple data sources like Amazon RDS, Amazon S3, Amazon Redshift, and Amazon Athena. Here is how to go about these configurations.<\/p>\n<h4>Amazon Redshift<\/h4>\n<p>To connect to Redshift:<\/p>\n<ul>\n<li>Open the Power BI Desktop<\/li>\n<li>Click \u201cGet Data\u201d<\/li>\n<li>From the list of data sources, select Amazon Redshift<\/li>\n<li>Input the server name (endpoint) and the database name<\/li>\n<li>Click OK<\/li>\n<li>Input your username and password<\/li>\n<li>Click Connect.<\/li>\n<\/ul>\n<h4>Amazon Athena<\/h4>\n<p>To connect to Athena:<\/p>\n<ul>\n<li>Open the Power BI Desktop<\/li>\n<li>Click \u201cGet Data\u201d<\/li>\n<li>Select Amazon Athena<\/li>\n<li>Input your AWS region and S3 staging directory<\/li>\n<li>Click Connect<\/li>\n<li>Input your AWS Access Key ID and Secret Access Key.<\/li>\n<\/ul>\n<h4>Amazon RDS (e.g., MySQL, PostgreSQL)<\/h4>\n<ul>\n<li>Get RDS Endpoint and Credentials<\/li>\n<li>Obtain the endpoint, database name, user name, and password for your RDS instance.<\/li>\n<li>Connect to RDS<\/li>\n<li>Open the Power BI Desktop<\/li>\n<li>Click \u201cGet Data.\u201d<\/li>\n<li>Select the appropriate database type (e.g PostgreSQL, MySQL)<\/li>\n<li>Input the server name (endpoint) and database name<\/li>\n<li>Click OK<\/li>\n<li>Input the user name and password<\/li>\n<li>Click Connect.<\/li>\n<\/ul>\n<h4>Amazon S3<\/h4>\n<ul>\n<li>You need the AWS credentials and the necessary permissions to access the S3 bucket<\/li>\n<li>Connect to S3<\/li>\n<li>Open the Power BI Desktop<\/li>\n<li>Click \u201cGet Data.\u201d<\/li>\n<li>Select Amazon S3<\/li>\n<li>Input the bucket URL<\/li>\n<li>Click Connect<\/li>\n<li>Input the AWS Access Key ID and Secret Access Key.<\/li>\n<\/ul>\n<h3>Configure Data Refresh (Optional)<\/h3>\n<p>To set up data refresh, you&#8217;ll have to navigate to the <a href=\"https:\/\/chartexpo.com\/services\" target=\"_blank\" rel=\"noopener noreferrer\">Power BI Service<\/a>, locate your dataset, and click on scheduled refresh. After that, you&#8217;ll have to input your AWS credentials and set up the refresh schedule.<\/p>\n<h2 id=\"how-to-create-visualizations-in-power-bi\">How to Visualize AWS Integration Data in Power BI<\/h2>\n<p>You can visualize AWS integration data using the <a href=\"https:\/\/chartexpo.com\/blog\/sankey-diagram-in-power-bi\" target=\"_blank\" rel=\"noopener\">Sankey diagram in Power\u00a0<\/a><span style=\"box-sizing: border-box; margin: 0px; padding: 0px;\"><a href=\"https:\/\/chartexpo.com\/blog\/sankey-diagram-in-power-bi\" target=\"_blank\" rel=\"noopener\">BI\u00a0<\/a>to<\/span> track relationships and data movement. With a <a href=\"https:\/\/chartexpo.com\/charts\/sankey-diagram\" target=\"_blank\" rel=\"noopener\">Sankey diagram maker<\/a>, you can easily create interactive, dynamic flows that make complex data easier to understand and analyze.\u201d<\/p>\n<p><strong>Stage 1: Logging in to Power BI<\/strong><\/p>\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<h4>Stage 2: Creating a Data Set and Selecting the Data Set to Use in Your Chart<\/h4>\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\/MTYrYmxvZytwYitjZXhwbytQQkk2MzIrU2Fua2V5Kw==\" 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\/MTYrYmxvZytncytjZXhwbytDRTYzMis=\" 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\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTYzMis=\" 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 width=\"68\"><strong>Total Cost<\/strong><\/td>\n<td width=\"99\"><strong>Company Type<\/strong><\/td>\n<td width=\"168\"><strong>Company Name<\/strong><\/td>\n<td width=\"153\"><strong>Expertise Categories<\/strong><\/td>\n<td width=\"132\"><strong>Expertise<\/strong><\/td>\n<td width=\"42\"><strong>Cost<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Skyline Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Plumbing &amp; Heating<\/td>\n<td>15456<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Skyline Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Mechanical Work<\/td>\n<td>10159<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Onyx General Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Plumbing &amp; Heating<\/td>\n<td>18045<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Onyx General Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Mechanical Work<\/td>\n<td>12695<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Living Well Remodeling<\/td>\n<td>Mechanical Installation<\/td>\n<td>Plumbing &amp; Heating<\/td>\n<td>14589<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Living Well Remodeling<\/td>\n<td>Mechanical Installation<\/td>\n<td>Welding<\/td>\n<td>11456<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Power-up Builders<\/td>\n<td>Raw Material<\/td>\n<td>Cement<\/td>\n<td>20561<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Power-up Builders<\/td>\n<td>Raw Material<\/td>\n<td>Steel<\/td>\n<td>32456<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Five-star Construction<\/td>\n<td>Raw Material<\/td>\n<td>Bricks<\/td>\n<td>10253<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Five-star Construction<\/td>\n<td>Raw Material<\/td>\n<td>Timber<\/td>\n<td>9000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>Paste the data table into the \u201cPower Query\u201d window. Next, choose 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\/09\/click-create-a-dataset-only-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/click-create-a-dataset-only-after-connecting-power-bi-and-aws.jpg\" alt=\"Click Create a Dataset Only After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Navigate to the left-side menu, and click the &#8220;Data Hub&#8221; option. Power BI will populate the data set list. If the data set has not 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\/09\/click-data-hub-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/click-data-hub-after-connecting-power-bi-and-aws.jpg\" alt=\"Click Data Hub After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Choose your preferred data set to be used for the Sankey diagram. After that, Power BI will populate the screen as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/choose-preferred-data-set-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/choose-preferred-data-set-after-connecting-power-bi-and-aws.jpg\" alt=\"Choose Preferred Data Set After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on the \u201cCreate a report\u201d dropdown, and select \u201cStart from scratch.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/click-create-a-report-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/click-create-a-report-after-connecting-power-bi-and-aws.jpg\" alt=\"Click Create a Report After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>The Report Canvas screen will appear as shown below:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/see-report-canvas-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/see-report-canvas-after-connecting-power-bi-and-aws.jpg\" alt=\"See Report Canvas After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<p><strong>Stage 3: Add the Power BI Sankey Diagram Extension by ChartExpo<\/strong><\/p>\n<ul>\n<li>To create a Sankey Diagram, you&#8217;ll need an add-in or Power BI visual from AppSource. You&#8217;ll have to navigate to the right side of the Power BI dashboard and open the visualizations panel. To import the Power BI Sankey Diagram extension by ChartExpo, click the ellipsis symbol (&#8230;).<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/click-3-dots-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/click-3-dots-after-connecting-power-bi-and-aws.jpg\" alt=\"Click 3 Dots After Connecting Power BI and AWS\" width=\"641\" \/><\/a><\/div>\n<ul>\n<li>On the 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\/09\/select-get-more-visuals-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/select-get-more-visuals-after-connecting-power-bi-and-aws.jpg\" alt=\"Select Get More Visuals After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Input \u201cSankey Diagram for Power by ChartExpo&#8221; into the search box. After that, 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\/09\/search-sankey-diagram-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/search-sankey-diagram-after-connecting-power-bi-and-aws.jpg\" alt=\"Search Sankey Diagram After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click the \u201cAdd\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/click-add-button-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/click-add-button-after-connecting-power-bi-and-aws.jpg\" alt=\"Click Add Button After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>The \u201cSankey Diagram for Power BI by ChartExpo&#8221; icon will be added to the visualization panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/see-sankey-diagram-in-visualization-panel-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/see-sankey-diagram-in-visualization-panel-after-connecting-power-bi-and-aws.jpg\" alt=\"See Sankey Diagram in Visualization Panel After Connecting Power BI and AWS\" width=\"236\" \/><\/a><\/div>\n<p><strong>Stage 4: Draw a Sankey Diagram with ChartExpo&#8217;s Power BI extension<\/strong><\/p>\n<ul>\n<li>To do that, select the \u201cSankey Diagram for Power BI by ChartExpo\u201d icon from the visualization panel. A window similar to the one below will open 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\/09\/select-sankey-diagram-icon-from-visualization-panel-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/select-sankey-diagram-icon-from-visualization-panel-after-connecting-power-bi-and-aws.jpg\" alt=\"Select Sankey Diagram Icon From Visualization Panel After Connecting Power BI and AWS\" width=\"373\" \/><\/a><\/div>\n<ul>\n<li>You can resize the visual. Next, navigate to the right side of the <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-dashboards-design\" target=\"_blank\" rel=\"noopener noreferrer\">Power BI dashboard<\/a>. Look out for \u201cFields\u201d found next to \u201cVisualizations.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/look-out-fields-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/look-out-fields-after-connecting-power-bi-and-aws.jpg\" alt=\"Look Out Fields After Connecting Power BI and AWS\" width=\"450\" \/><\/a><\/div>\n<ul>\n<li>You have to select the fields in the following sequence:<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Total Cost<\/li>\n<li>Company Type<\/li>\n<li>Company Name<\/li>\n<li>Expertise Categories<\/li>\n<li>Expertise<\/li>\n<li>Cost<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/select-fields-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/select-fields-after-connecting-power-bi-and-aws.jpg\" alt=\"Select Fields After Connecting Power BI and AWS\" width=\"219\" \/><\/a><\/div>\n<ul>\n<li>You&#8217;ll have to provide your email address or ChartExpo license key.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/enter-email-address-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/enter-email-address-after-connecting-power-bi-and-aws.jpg\" alt=\"Enter Email Address After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<p><strong>Stage 5: Activate the ChartExpo Trial or Apply a Subscription Key<\/strong><\/p>\n<ul>\n<li>Select the ChartExpo visual. After that, navigate to the visualizations panel and look out for the three icons below \u201cBuild Visual.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/select-visual-look-for-three-icon-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/select-visual-look-for-three-icon-after-connecting-power-bi-and-aws.jpg\" alt=\"Select Visual Look For Three Icon After Connecting Power BI and AWS\" width=\"257\" \/><\/a><\/div>\n<ul>\n<li>Choose the middle icon \u201cFormat visual.\u201d Next, the visual properties will be populated as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/choose-format-visual-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/choose-format-visual-after-connecting-power-bi-and-aws.jpg\" alt=\"Choose Format Visual After Connecting Power BI and AWS\" width=\"238\" \/><\/a><\/div>\n<ul>\n<li>As a new user, look out for the textbox under the \u201cTrial Mode,\u201d and input your email address. After that, toggle \u201cEnable Trial&#8217; to activate the 7-day trial.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/activate-7-day-trial-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/activate-7-day-trial-after-connecting-power-bi-and-aws.jpg\" alt=\"Activate 7 Day Trial After Connecting Power BI and AWS\" width=\"239\" \/><\/a><\/div>\n<ul>\n<li>You&#8217;ll notice that the Sankey Diagram comes with the ChartExpo watermark.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/notice-sankey-diagram-with-watermark-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/notice-sankey-diagram-with-watermark-after-connecting-power-bi-and-aws.jpg\" alt=\"Notice Sankey Diagram With Watermark After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>If you have a license key, navigate to the \u201cLicense Settings\u201d section, and input it into the \u201cChartExpo License Key\u201d textbox. After that, you&#8217;ll have to slide the toggle switch next to \u201cEnable License\u201d to \u201cOn.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/enter-license-key-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/enter-license-key-after-connecting-power-bi-and-aws.jpg\" alt=\"Enter License Key After Connecting Power BI and AWS\" width=\"233\" \/><\/a><\/div>\n<ul>\n<li>You&#8217;ll notice that the Sankey diagram doesn&#8217;t come with a watermark.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/notice-sankey-diagram-without-watermark-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/notice-sankey-diagram-without-watermark-after-connecting-power-bi-and-aws.jpg\" alt=\"Notice Sankey Diagram WIthout Watermark After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To add a prefix (like the $ sign) with the numeric values in the chart, you&#8217;ll have to expand the \u201cStats\u201d properties and include the prefix value.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/add-prefix-in-chart-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/add-prefix-in-chart-after-connecting-power-bi-and-aws.jpg\" alt=\"Add Prefix in Chart After Connecting Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To add colors to each node, expand the \u201cLevel Colors\u201d properties and select the colors.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/add-colors-to-each-node-after-connecting-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/add-colors-to-each-node-after-connecting-power-bi-and-aws.jpg\" alt=\"Add Colors to Each Node After Connecting Power BI and AWS\" width=\"223\" \/><\/a><\/div>\n<ul>\n<li>Changes will be saved automatically.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/final-power-bi-and-aws.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/final-power-bi-and-aws.jpg\" alt=\"Final Power BI and AWS\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk2MzIrU2Fua2V5Kw==\" 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\/MTYrYmxvZytncytjZXhwbytDRTYzMis=\" 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\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTYzMis=\" 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<p>Here are three insights from the chart.<\/p>\n<ul>\n<li>At Level 1 (Total Cost), the procurement cost is $155K.<\/li>\n<li>At Level 2 (Company Type), out of the $155K cost, $82.4K (53.3%) was spent on subcontractors, while $72.3K (46.7%) was allocated to the supplier.<\/li>\n<li>At Level 3 (Company Name), the $72.3K supplier cost was divided between two companies: Five-star Construction and Power-up Builder with charges of $19.3K and $53.0K, respectively.<\/li>\n<\/ul>\n<h3>Transform Data into Actionable Insights with Power BI:<\/h3>\n<p>Discover the power of combining Power BI and AWS in this hands-on tutorial. By integrating these two powerful platforms, you can visualize and analyze your AWS data with ease, leveraging Power BI\u2019s advanced charting and graphing capabilities. Whether it&#8217;s analyzing cloud storage usage, monitoring performance metrics, or visualizing cost trends, this integration enables you to transform complex AWS data into clear, actionable insights. Mastering Power BI and AWS together empowers you to make data-driven decisions, optimize cloud resources, and enhance reporting accuracy. With rich visuals and dynamic graphs, you can unlock deeper insights, improve collaboration, and drive smarter business strategies.<\/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\"><\/iframe><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk2MzIrU2Fua2V5Kw==\" 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\/MTYrYmxvZytncytjZXhwbytDRTYzMis=\" 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\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTYzMis=\" 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<h2 id=\"what-are-the-benefits-of-power-bi-integration-with-aws\">What are the Benefits of Power BI Integration with AWS?<\/h2>\n<ul>\n<li><strong>Scalability:<\/strong> You&#8217;ll take advantage of the AWS infrastructure to handle <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-dataset\" target=\"_blank\" rel=\"noopener noreferrer\">large datasets<\/a> and complex analytics demands.<\/li>\n<li><strong>Data Accessibility:<\/strong> It helps the user access and integrate data from multiple AWS services like RDS, S3, Athena, and Amazon Redshift. This will enable comprehensive and unified <a href=\"https:\/\/chartexpo.com\/blog\/exploratory-data-analysis\" target=\"_blank\" rel=\"noopener noreferrer\">data analysis<\/a>.<\/li>\n<li><strong>Cost Efficiency:<\/strong> You can take advantage of AWS&#8217;s pay-as-you-go pricing model to optimize cost and avoid upfront infrastructure investments.<\/li>\n<li><strong>Security and Compliance:<\/strong> The AWS&#8217;s robust security features and compliance certifications meet regulatory requirements and ascertain data security.<\/li>\n<\/ul>\n<h2>FAQs<\/h2>\n<h3>Can Power BI be used with AWS?<\/h3>\n<p>Yes. To use Power BI with AWS, you&#8217;ll have to connect to AWS data sources like RDS, S3, Athena, and Redshift. That will enable comprehensive data analysis and visualization.<\/p>\n<h3>Can we connect Power BI to AWSS3?<\/h3>\n<p>Yes, you can connect Power BI to AWS S3. To do that, you&#8217;ll have to use Amazon Athena as a bridge, and that helps stored data in S3 to be visualized and queried in Power BI.<\/p>\n<h3>What is similar to Power BI in AWS?<\/h3>\n<p>The AWS Quick Sight is similar to Power BI. It offers cloud-based business intelligence and data visualization tools. This will, in turn, allow users to create and share interactive dashboards and reports from multiple data sources.<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Power BI AWS involves the use of Power BI for data analytics and AWS services like S3, RDS, and Redshift. The major advantages of using Power BI AWS include enhanced data accessibility, scalability, and taking advantage of AWS&#8217;s infrastructure for cost efficiency and performance.<\/p>\n<p>To get the most out of the Power BI AWS, you&#8217;ll have to ascertain that the data models are optimized for performance. Furthermore, you&#8217;ll have to manage and monitor AWS service usage to control costs. AWS offers flexibility in deploying and designing data solutions tailored to your business needs. This will, in turn, enhance innovation and agility in analytics projects.<\/p>\n<p>Now you know what Power BI AWS is, why will you use it for your data visualization and analysis?<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Learn how to integrate Power BI with AWS for improved analytics. This guide covers setup &#038; benefits of using Power BI with AWS services for effective insights.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/power-bi-and-aws\"><\/a><\/p>","protected":false},"author":1,"featured_media":39744,"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 and AWS Integration for Better Data Insights -<\/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-and-aws\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"Power BI and AWS Integration for Better Data Insights -\" \/>\r\n<meta name=\"twitter:description\" content=\"Learn how to integrate Power BI with AWS for improved analytics. This guide covers setup &amp; benefits of using Power BI with AWS services for effective insights.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/feature-ce632-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 and AWS Integration for Better Data Insights -","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-and-aws","twitter_card":"summary_large_image","twitter_title":"Power BI and AWS Integration for Better Data Insights -","twitter_description":"Learn how to integrate Power BI with AWS for improved analytics. This guide covers setup & benefits of using Power BI with AWS services for effective insights.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/feature-ce632-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-and-aws","url":"https:\/\/chartexpo.com\/blog\/power-bi-and-aws","name":"Power BI and AWS Integration for Better Data Insights -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2024-09-06T15:19:55+00:00","dateModified":"2025-11-13T08:36:16+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/power-bi-and-aws#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/power-bi-and-aws"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/power-bi-and-aws#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"Power BI and AWS Integration for Better Data Insights"}]},{"@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\/39731"}],"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=39731"}],"version-history":[{"count":11,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/39731\/revisions"}],"predecessor-version":[{"id":55705,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/39731\/revisions\/55705"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/39744"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=39731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=39731"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=39731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}