{"id":2919,"date":"2022-10-28T20:33:43","date_gmt":"2022-10-28T15:03:43","guid":{"rendered":"https:\/\/easyinsights.ai\/?p=2919"},"modified":"2025-01-02T16:02:23","modified_gmt":"2025-01-02T10:32:23","slug":"how-to-connect-power-bi-with-postgresql","status":"publish","type":"post","link":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/","title":{"rendered":"3 Ways to Connect Power BI with Postgres"},"content":{"rendered":"<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Reading Time: <\/span> <span class=\"rt-time\"> 8<\/span> <span class=\"rt-label rt-postfix\">minutes<\/span><\/span><div class=\"wp-block-image is-resized\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"536\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/10\/PowerBI-1024x536.png\" alt=\"PowerBI\" class=\"wp-image-2920\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-1024x536.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-300x157.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-768x402.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-940x492.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-345x181.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-525x275.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-720x377.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-626x328.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-298x156.png 298w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-455x238.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-625x327.png 625w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-508x266.png 508w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-764x400.png 764w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-340x178.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-293x153.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-267x140.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-195x102.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-50x26.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-60x31.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>Power BI&#8217;s popularity among advanced users grows by the day. It helps analyze different data sources within the same console because it is a user-friendly tool with multiple data sources to connect to. Most BI tools support connections to a variety of databases and APIs. PostgreSQL is a popular database that is well-suited for BI applications. The purpose of this article is to describe the most common methods for connecting PostgreSQL to Power BI in order to perform analytics and generate reports in real-time.<\/p>\n\n\n\n<p><strong>Also read:<\/strong> How to connect <strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-tableau-with-postgres\/\" target=\"_blank\" rel=\"noreferrer noopener\">Tableau with Postgres<\/a><\/span><\/strong>, and <strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-google-data-studio-with-postgres\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Data Studio with Postgres<\/a><\/span><\/strong><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Jump ahead to:<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#What_is_Power_BI\" >What is Power BI?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#What_is_PostgreSQL\" >What is PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#Why_connect_PostgreSQL_with_Power_BI\" >Why connect PostgreSQL with Power BI?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#Ways_to_Connect_Power_BI_with_Postgres\" >Ways to Connect Power BI with Postgres&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#Benefits_Of_Using_EasyInsights\" >Benefits Of Using EasyInsights<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#Wrapping_Up\" >Wrapping Up<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#Bonus_Read_Unlock_First-Party_Data_for_Audience_Activation_and_Data_Enrichment\" >Bonus Read: Unlock First-Party Data for Audience Activation and Data Enrichment<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_Power_BI\"><\/span>What is Power BI?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Microsoft Power BI Desktop is a cutting-edge Business Intelligence tool designed for data analysts. You can connect it to any data source and then transform and visualize the data using Power BI. Power BI accepts data from various databases, webpages, or structured files such as spreadsheets, CSV, XML, and JSON and uses data transformation and visualization features to provide meaningful insights.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_PostgreSQL\"><\/span>What is PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>PostgreSQL is widely regarded as one of the most sophisticated open-source databases. It is strong and well-suited for BI applications. It is scalable and beautifully designed. PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language and includes numerous features for safely storing and scaling the most complex data workloads.&nbsp;<\/p>\n\n\n\n<p><strong><em>Additional Reading: <a href=\"https:\/\/easyinsights.ai\/blog\/customer-data-platforms-cdps-a-comprehensive-guide\/\">Leverage Data Warehouses with Composable CDPs<\/a><\/em><\/strong><\/p>\n\n\n\n<p>PostgreSQL includes numerous features designed to assist developers in building applications, administrators in protecting data integrity and building fault-tolerant environments, and you in managing your data regardless of how large or small the dataset. This is why it is so popular on the market.<\/p>\n\n\n\n<p>According to the StackOverflow &#8220;<a href=\"https:\/\/insights.stackoverflow.com\/survey\/2021#technology-most-popular-technologies\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><span style=\"text-decoration: underline;\">2021 Developers Survey<\/span><\/strong><\/a>&#8220;, PostgreSQL is the second most-used database technology, trailing only MySQL, and its popularity is growing steadily. Because even though only about <a href=\"https:\/\/insights.stackoverflow.com\/survey\/2017#most-popular-technologies\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><span style=\"text-decoration: underline;\">26% of developers were using it in 2017<\/span><\/strong><\/a>, that number rose to <a href=\"https:\/\/insights.stackoverflow.com\/survey\/2019#most-popular-technologies\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><span style=\"text-decoration: underline;\">34% in 2019<\/span><\/strong><\/a> and even more than <strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/insights.stackoverflow.com\/survey\/2021#most-popular-technologies\" target=\"_blank\" rel=\"noreferrer noopener\">40% in 2021<\/a>.<\/span><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_connect_PostgreSQL_with_Power_BI\"><\/span>Why connect PostgreSQL with Power BI?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Microsoft&#8217;s popular Business Intelligence platform is PowerBI. Connecting your PostgreSQL database to PowerBI allows you to consolidate all of your data and perform holistic analysis. This will allow you to make more informed business decisions. PowerBI will help with data exploration as well as data integration. To gain new insights into your data, you can select from a variety of graphs and charts. It also makes data visualization easier by providing a drag-and-drop interface, and you can also easily create reports.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ways_to_Connect_Power_BI_with_Postgres\"><\/span>Ways to Connect Power BI with Postgres&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The majority of BI solutions support multiple APIs and databases. Microsoft Power BI is a popular business intelligence tool, and PostgreSQL is a popular database. Here\u2019s how to connect them&nbsp;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Using Npgsql<\/strong><\/li>\n<\/ol>\n\n\n\n<p>Download and install the latest version of Npgsql as Administrator on your computer while enabling GAC Installation. Restart your computer and launch Power BI Desktop. Select &#8216;PostgreSQL database&#8217; from the &#8216;Get Data&#8217; menu. Enter the Server and Database names and the User and Password. Select the table you require in the Navigator window and Load it. However, if this does not work, you can try an ODBC connection.<\/p>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Using an ODBC Connection<\/strong><\/li>\n<\/ol>\n\n\n\n<p>Open Database Connectivity (ODBC) is a standard API for accessing DBMS (Wikipedia). ODBC was created to be independent of databases and operating systems. How do you use ODBC to connect PostgreSQL to Power BI Desktop?<\/p>\n\n\n\n<p>To begin, download and install <strong>psqlODBC<\/strong> from the official website.<\/p>\n\n\n\n<p>You must now complete two setups. One is from Power BI, while the other is from PostgreSQL.&nbsp;<\/p>\n\n\n\n<p>Open Power BI Desktop and select <strong>&#8216;Get Data&#8217;<\/strong> after downloading and installing psqlODBC x64. Look for and <strong>select ODBC. Select Connect.<\/strong><\/p>\n\n\n\n<p>When prompted to choose a <strong>Data Source<\/strong>, select <strong>None<\/strong>. Enter the <strong>non-credential properties<\/strong> in the connection string (Driver, Server, Port, and Database).<\/p>\n\n\n\n<p>The connection string looks like this:<\/p>\n\n\n\n<p><strong>Driver={PostgreSQL ANSI(x64)}; Server=localhost; Port=5433; Database= my_database<\/strong><\/p>\n\n\n\n<p>If you have previously entered your credential information, you may want to clear the permissions. To do so, navigate to <strong>Options and settings<\/strong>, then <strong>Data source settings<\/strong>, and finally <strong>Clear Permissions.<\/strong><\/p>\n\n\n\n<p>After that, <strong>select Database<\/strong> on the credential screen and enter the <strong>Username and Password<\/strong>. In the data structure, you can now select the table with which you want to work.<\/p>\n\n\n\n<p>You must also configure the remote connection if your database is in the cloud. You must do this by editing the pga hba.conf and postgresql.conf files.<\/p>\n\n\n\n<p>The pg hba.conf file should be edited as follows:<\/p>\n\n\n<div class=\"wp-block-image is-resized\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/6bg22tjK2noEmSI9ZNVa1ntTUYDqE7SYRWTCEoQMuqEh5otKVnnM8aHhrIPtVL7uI7cFeZHiaG8HQR57RLpIjDQDa-DTngHPGDGnDKROEdl8LPplAMTfC9_nIcEt_ZhLnxklDzbmaxPhGlqQJ7WBWwQtbfUuabhVgVE04kvbN38XvXJmfrJwT-9jpQ.png\" alt=\"Postgres SQL configuration file\"\/><\/figure><\/div>\n\n\n<p>This is how you should edit the postgresql.conf file:<\/p>\n\n\n<div class=\"wp-block-image is-resized\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/31qwiC3TwVYaDYuia9VEWyruvniRKIyVVjXnjWZVBjuHr_6JQWq6wzolfzsUyaXsBInzCZ6h3H46inprWNeB30OKwf-Bwzpu8OsnJKnyMuoqgoMAoy5gYRgDyl6igPWlli39ofO5tW_4Dtw5nvGVdyEMOA9UIQwATQzx4gG1GXWgoHyIxhZXSXXfow.png\" alt=\"Postgres SQL configuration file\"\/><\/figure><\/div>\n\n\n<p>You must <strong>restart PostgreSQL<\/strong> after editing these files. You can also restrict who can access the database using the IP address from your cloud source.<\/p>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>Using EasyInsights<\/strong><\/li>\n<\/ol>\n\n\n\n<p>While Power BI offers a plethora of data input options, connecting Power BI to PostgreSQL is not without its challenges. The simplest way to connect PostgreSQL to Power BI is to click on &#8216;Get Data&#8217; on the Power BI Home page and select a source.&nbsp;<\/p>\n\n\n\n<p>Unfortunately, It would be a cumbersome and time-consuming task to collect data from different marketing and analytics platforms like Google Ads, Facebook, LinkedIn, Google Analytics, etc. and maintain it in a Postgres database. <\/p>\n\n\n\n<p class=\"has-text-color has-background\" style=\"color:#2c01ca;background-color:#e2dff4\"><strong>It takes more than 40% of the marketers&#8217; time just to log in to the multiple platforms and export, transform and upload it to the BI tools.<\/strong><\/p>\n\n\n\n<p>You can solve this issue with EasyInsights. It enables faster data movement from databases such as PostgreSQL, SaaS applications, and other data sources into your data warehouse for visualization in a BI tool. EasyInsights is completely automated, so no coding is required. EasyInsights is an effective tool that helps establish a live connection between Microsoft Power BI Desktop and PostgreSQL.&nbsp;<\/p>\n\n\n\n<p>Here&#8217;s how you can establish a live connection between Microsoft Power BI and PostgreSQL using <a href=\"https:\/\/easyinsights.ai\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><span style=\"text-decoration: underline;\">EasyInsights<\/span><\/strong><\/a>. <\/p>\n\n\n\n<p>Follow the steps below to connect Microsoft Power BI and EasyInsights.<\/p>\n\n\n\n<p><strong>Step 1: Launch Power BI Desktop.<\/strong><\/p>\n\n\n\n<p>Note: New users should click Get Started, then Add data from another source. Repeat users should select Get Data from the top left navigation bar.<\/p>\n\n\n<div class=\"wp-block-image is-resized\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/9Zrnojm8HbJf0iDHZF_fYUGgh4gNi2W5a29M2i_sGMZlvUJedpU46tWECgZvj9tMM5W5DWGQXAJTmEnAI-wPw_p4uISGeM9pP1IPi0zTHEzQcai9deHAzew4eorfovpN5Zu3G1UxMSUBZNdnXn-BndhpABRjavAS_TqUeMgyLHWkkNY2RgUQuS4Jcg.png\" alt=\"Microsoft Power BI\"\/><\/figure><\/div>\n\n\n<p><strong>Step 2: <\/strong>In the dialogue box, under the database option, select &#8216;PostgreSQL database&#8217; and click &#8216;Connect.&#8217;<\/p>\n\n\n<div class=\"wp-block-image is-resized\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/383U27OYVljZOWsZBEwMDqpVvMNHzKmZ_ckdKG2BQLYGh2lwoJ9RZI8zo3tb6FjpnKxSwt4yaHQYIoZyxbg3TorNEglC6b4BjHvnTxG5bEQNRlrvG9ji8WbNRkYYRVh5g9khiitEwxFjFINCNgkALz2cpoyqQPndaKYNMF3DbslIEzu-fJExRVMIJw.png\" alt=\"Postgres as a data source in Microsoft Power BI\"\/><\/figure><\/div>\n\n\n<p><strong>Step 3: <\/strong>In the following dialogue box, enter the server IP address and database name. This information can be found on the <a href=\"https:\/\/easyinsights.ai\/integrations\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><span style=\"text-decoration: underline;\">data destination page<\/span><\/strong><\/a>.\u00a0<\/p>\n\n\n<div class=\"wp-block-image is-resized\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/cFz9UMzdSUSZ1R6wVrg0lVRR9pcr_UWP34Xxdy7hbBLB7D2qUbO-onYs8_FN_opDF42TIhpL5OBcQEaLB02NfURwHs2rEZBSV-uO1HA0ZpZY4Cr_lULQw0dSPHLZFsLmGWj1t3e-yxOOmF_iF5j4g-SU_PD4CwOcz-2cLv2pJqVuDbjVMz42TRLnwA.png\" alt=\"Postgres configuration in Microsoft Power BI\"\/><\/figure><\/div>\n\n\n<p><strong>Step 4: <\/strong>Enter your username and password in the following dialogue box and click Connect. This information can be found on the <a href=\"https:\/\/app.easyinsights.ai\/destination\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><span style=\"text-decoration: underline;\">data destination page<\/span><\/strong><\/a>.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image is-resized\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/rqAhaqtyCoUOEp37PPA-5Y0MHIS1xfJfTw_s788PL9vyAvfOpUVcNTCcfnt6DzO8NpTf8yM_KDsi8rwMAItN0Vms2lRG5OnEaP2OFdaRoKbYaKmz7BK1hk1vQ7VVxrDgLwSDSvu4DWhGIFTI9-wdQratsrxiuedOtZkdGY5y28lCKZv04s45CK1kIA.png\" alt=\"Postgres configuration in Microsoft Power BI\"\/><\/figure><\/div>\n\n\n<p><strong>Step 5:<\/strong> Select and load the table you want to use from the Navigator dialogue bar. If Power BI warns you about encryption, click OK.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-background\" style=\"color:#2c01ca;background-color:#e2dff4\"><span class=\"ez-toc-section\" id=\"Benefits_Of_Using_EasyInsights\"><\/span>Benefits Of Using EasyInsights<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul style=\"color:#2c01ca;background-color:#e2dff4\" class=\"wp-block-list has-text-color has-background\">\n<li><strong>Completely automated:<\/strong> The EasyInsights platform is simple to set up and requires little maintenance.<\/li>\n\n\n\n<li><strong>Real-time Data Transfer:<\/strong> EasyInsights offers real-time data migration so that you always have analysis-ready data.<\/li>\n\n\n\n<li><strong>100% Complete &amp; Accurate Data Transfer: <\/strong>EasyInsight&#8217;s robust infrastructure ensures dependable data transfer with no data loss.<\/li>\n\n\n\n<li><strong>Scalability:<\/strong> EasyInsights has built-in integrations from all the popular marketing data sources, allowing you to scale your data infrastructure as needed.<\/li>\n\n\n\n<li><strong>Generate Insightful reports:<\/strong> EasyInsights helps in generating useful reports. Use reports on Google Sheets to make faster data decisions, or consume it from your inbox.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Wrapping_Up\"><\/span>Wrapping Up<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>EasyInsights supports pre-built data integrations from all the popular marketing data sources. It provides a fully managed solution for your Power BI data migration process. It will automate your data flow in minutes without requiring you to write a single line of code. EasyInsights provides a truly efficient and fully automated solution for managing data in real time and always having analysis-ready data at Power BI.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bonus_Read_Unlock_First-Party_Data_for_Audience_Activation_and_Data_Enrichment\"><\/span>Bonus Read: Unlock First-Party Data for Audience Activation and Data Enrichment<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"449\" src=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-1024x449.png\" alt=\"what is data activation\" class=\"wp-image-7490\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-1024x449.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-300x131.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-768x337.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-940x412.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-345x151.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-525x230.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-720x316.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-626x274.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-586x257.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-880x386.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-455x199.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-340x149.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-293x128.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-267x117.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-195x85.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-50x22.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2-60x26.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2024\/02\/infographic-da2.png 1157w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>EasyInsights works with data from various platforms for data activation and data enrichment in a few key ways:<\/p>\n\n\n\n<p><strong>Data Collection and Transformation:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>EasyInsights<strong> <\/strong>connect directly to your CRMs, ad platforms, analytic platforms, CEPs and other tools allowing it to access and extract the raw data you&#8217;ve collected.<\/li>\n\n\n\n<li><strong>Data Transformation:<\/strong>&nbsp;EasyInsights then cleans,&nbsp;normalizes,&nbsp;and enriches the data to make it usable for activation purposes.&nbsp;This may involve tasks like:\n<ul class=\"wp-block-list\">\n<li><strong>Formatting data:<\/strong>&nbsp;Ensuring all data points are in a consistent format.<\/li>\n\n\n\n<li><strong>Handling missing values:<\/strong>&nbsp;Filling in missing data points or removing them according to your preferences.<\/li>\n\n\n\n<li><strong>Enriching data:<\/strong>&nbsp;Adding additional data points from other sources to create a more comprehensive picture of your customers.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>Data Activation:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Segmentation and Targeting:<\/strong>&nbsp;It allows you to segment your audience based on various criteria like demographics,&nbsp;behavior,&nbsp;and interests using the enriched first-party data.<\/li>\n\n\n\n<li><strong>Multi-channel Marketing:<\/strong>&nbsp;You can then use these segments to activate your audience across different marketing channels like email,&nbsp;social media,&nbsp;and advertising platforms.<\/li>\n\n\n\n<li><strong>Customer Relationship Management (CRM):<\/strong>&nbsp;The data can be used to personalize outreach and interactions with customers within your CRM system.<\/li>\n\n\n\n<li><strong>Marketing Attribution:<\/strong>&nbsp;EasyInsights can help you understand how different marketing channels contribute to conversions and optimize your marketing spend accordingly.<\/li>\n<\/ul>\n\n\n\n<p><strong>Key Feature:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Offers features like customer data platform (CDP) capabilities,&nbsp;marketing automation,&nbsp;and campaign management tools.<\/li>\n\n\n\n<li>Focuses on reverse ETL (extracting data from your warehouse and sending it to marketing tools) and offers pre-built integrations with various marketing platforms.<\/li>\n<\/ul>\n\n\n\n<div style=\"background-color:#e2dff4;color:#2c01ca; padding:10px\">\n<p style=\"background-color:#e2dff4;color:#2c01ca\">EasyInsights is a marketer&#8217;s preferred tool for first party data activation.<\/p><p style=\"background-color:#e2dff4;color:#2c01ca\">In this age of cross-channel marketing, EasyInsights offers a comprehensive platform to collect, store, and transform all your first-party data.<\/p><p style=\"background-color:#e2dff4;color:#2c01ca\">EasyInsights enhances marketing campaign efficiency in a cookieless landscape with accurate ad signals. It helps brands step away from surface-level metrics and unleash the potential of first-party data to optimize marketing strategies, ensuring a superior Return on Ad Spend (ROAS). It does all this, while being a highly affordable no-code platform with an exceptional customer support apparatus.<\/p><\/div>\n\n\n\n<p><a href=\"https:\/\/easyinsights.ai\/book-demo\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Sign up for a demo<\/strong><\/a> today to see EasyInsights in action.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Many organizations store their data on PostgreSQL Servers depending on the use case. Visualizing this data can be very beneficial in gathering important insights that can aid in objective decision-making in the organization. Microsoft Power BI is an excellent Business Intelligence tool for visualizing data stored in PostgreSQL Server. <\/p>\n","protected":false},"author":6,"featured_media":2920,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[123,134],"tags":[117,96,199,97],"class_list":["post-2919","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-tools","category-others","tag-data-visulaization","tag-marketing-dashbaords","tag-postgresql","tag-powerbi"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.3.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>3 Ways to Connect Power BI with Postgres - EasyInsights<\/title>\n<meta name=\"description\" content=\"This article will introduce you to PostgreSQL and three methods for integrating Microsoft Power BI and PostgreSQL to visualize your data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 Ways to Connect Power BI with Postgres - EasyInsights\" \/>\n<meta property=\"og:description\" content=\"This article will introduce you to PostgreSQL and three methods for integrating Microsoft Power BI and PostgreSQL to visualize your data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"EasyInsights\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/EasyInsightsai-522100504893809\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-28T15:03:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-02T10:32:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Piyush Gupta\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@easy_insights\" \/>\n<meta name=\"twitter:site\" content=\"@easy_insights\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Piyush Gupta\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/\"},\"author\":{\"name\":\"Piyush Gupta\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4\"},\"headline\":\"3 Ways to Connect Power BI with Postgres\",\"datePublished\":\"2022-10-28T15:03:43+00:00\",\"dateModified\":\"2025-01-02T10:32:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/\"},\"wordCount\":1627,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png\",\"keywords\":[\"data visulaization\",\"marketing dashbaords\",\"PostgreSQL\",\"powerbi\"],\"articleSection\":[\"BI Tools\",\"Others\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/\",\"url\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/\",\"name\":\"3 Ways to Connect Power BI with Postgres - EasyInsights\",\"isPartOf\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png\",\"datePublished\":\"2022-10-28T15:03:43+00:00\",\"dateModified\":\"2025-01-02T10:32:23+00:00\",\"description\":\"This article will introduce you to PostgreSQL and three methods for integrating Microsoft Power BI and PostgreSQL to visualize your data.\",\"breadcrumb\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#primaryimage\",\"url\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png\",\"contentUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png\",\"width\":1200,\"height\":628,\"caption\":\"PowerBI\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/easyinsights.ai\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 Ways to Connect Power BI with Postgres\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#website\",\"url\":\"https:\/\/easyinsights.ai\/blog\/\",\"name\":\"EasyInsights\",\"description\":\"Uncover Growth in Digital Marketing Data\",\"publisher\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/easyinsights.ai\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#organization\",\"name\":\"Easyinsights\",\"url\":\"https:\/\/easyinsights.ai\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png\",\"contentUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png\",\"width\":649,\"height\":117,\"caption\":\"Easyinsights\"},\"image\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/EasyInsightsai-522100504893809\",\"https:\/\/x.com\/easy_insights\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4\",\"name\":\"Piyush Gupta\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g\",\"caption\":\"Piyush Gupta\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"3 Ways to Connect Power BI with Postgres - EasyInsights","description":"This article will introduce you to PostgreSQL and three methods for integrating Microsoft Power BI and PostgreSQL to visualize your data.","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:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"3 Ways to Connect Power BI with Postgres - EasyInsights","og_description":"This article will introduce you to PostgreSQL and three methods for integrating Microsoft Power BI and PostgreSQL to visualize your data.","og_url":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/","og_site_name":"EasyInsights","article_publisher":"https:\/\/www.facebook.com\/EasyInsightsai-522100504893809","article_published_time":"2022-10-28T15:03:43+00:00","article_modified_time":"2025-01-02T10:32:23+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png","type":"image\/png"}],"author":"Piyush Gupta","twitter_card":"summary_large_image","twitter_creator":"@easy_insights","twitter_site":"@easy_insights","twitter_misc":{"Written by":"Piyush Gupta","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#article","isPartOf":{"@id":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/"},"author":{"name":"Piyush Gupta","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4"},"headline":"3 Ways to Connect Power BI with Postgres","datePublished":"2022-10-28T15:03:43+00:00","dateModified":"2025-01-02T10:32:23+00:00","mainEntityOfPage":{"@id":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/"},"wordCount":1627,"commentCount":1,"publisher":{"@id":"https:\/\/easyinsights.ai\/blog\/#organization"},"image":{"@id":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png","keywords":["data visulaization","marketing dashbaords","PostgreSQL","powerbi"],"articleSection":["BI Tools","Others"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/","url":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/","name":"3 Ways to Connect Power BI with Postgres - EasyInsights","isPartOf":{"@id":"https:\/\/easyinsights.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png","datePublished":"2022-10-28T15:03:43+00:00","dateModified":"2025-01-02T10:32:23+00:00","description":"This article will introduce you to PostgreSQL and three methods for integrating Microsoft Power BI and PostgreSQL to visualize your data.","breadcrumb":{"@id":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#primaryimage","url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png","contentUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI.png","width":1200,"height":628,"caption":"PowerBI"},{"@type":"BreadcrumbList","@id":"https:\/\/easyinsights.ai\/blog\/how-to-connect-power-bi-with-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/easyinsights.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"3 Ways to Connect Power BI with Postgres"}]},{"@type":"WebSite","@id":"https:\/\/easyinsights.ai\/blog\/#website","url":"https:\/\/easyinsights.ai\/blog\/","name":"EasyInsights","description":"Uncover Growth in Digital Marketing Data","publisher":{"@id":"https:\/\/easyinsights.ai\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/easyinsights.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/easyinsights.ai\/blog\/#organization","name":"Easyinsights","url":"https:\/\/easyinsights.ai\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png","contentUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png","width":649,"height":117,"caption":"Easyinsights"},"image":{"@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/EasyInsightsai-522100504893809","https:\/\/x.com\/easy_insights"]},{"@type":"Person","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4","name":"Piyush Gupta","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g","caption":"Piyush Gupta"}}]}},"fimg_url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/10\/PowerBI-1024x536.png","reading_time":"9 minutes","_links":{"self":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts\/2919"}],"collection":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/comments?post=2919"}],"version-history":[{"count":18,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts\/2919\/revisions"}],"predecessor-version":[{"id":8717,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts\/2919\/revisions\/8717"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/media\/2920"}],"wp:attachment":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/media?parent=2919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/categories?post=2919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/tags?post=2919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}