{"id":3754,"date":"2018-06-16T09:15:12","date_gmt":"2018-06-16T09:15:12","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=3754"},"modified":"2018-09-28T17:32:37","modified_gmt":"2018-09-28T17:32:37","slug":"how-to-import-linkedin-data-in-powerbi","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-import-linkedin-data-in-powerbi\/","title":{"rendered":"How to Import LinkedIn data in Power BI"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>In this article, we will learn how to\u00a0import LinkedIn data in Power BI<\/strong>. For that, we will create a successful OAuth Connection then request for reading LinkedIn Profile data and loading into Power BI<\/p>\n

Power BI is a very popular Business Analytic tool used to get business information. It is very popular because it is easy to install, simple to learn and very intuitive. Also, REST API is very popular these days and we wanted to show you a way to integrate them in Power BI with the help of the\u00a0ZappySys ODBC PowerPack<\/a>. This software includes powerful drivers to\u00a0query REST API<\/strong>\u00a0URL, Local\u00a0XML \/ JSON files<\/strong>\u00a0and\u00a0XML SOAP Web Service<\/strong>\u00a0with simple SQL queries.<\/p>\n

In nutshell,\u00a0this post will focus on how to call LinkedIn API using Zappysys ODBC PowerPack<\/a>. So let’s get started<\/p>\n

Prerequisite<\/span><\/h2>\n
    \n
  1. First, you will need to have\u00a0our\u00a0ZappySys ODBC Power Pack<\/a><\/li>\n
  2. In the second place, you will need to have internet access<\/li>\n
  3. On third place,\u00a0Power BI Desktop (FREE)<\/a>\u00a0installed<\/li>\n<\/ol>\n

    Getting Started<\/h2>\n

    In order to start, we will show several examples. ZappySys ODBC PowerPack includes the ZappySys JSON Driver that will help you to call LinkedIn API, retrieve basic profile data from LinkedIn and load profile\u00a0data in Power BI. To learn more about LinkedIn API check this help file<\/a>.<\/p>\n

    Call LinkedIn API using ZappySys JSON Driver<\/h2>\n

    To access LinkedIn data using REST API call you need to create a LinkedIn app. See this article,<\/a>\u00a0it has mentioned the steps for How to register an App in LinkedIn. once you registered OAuth app in the LinkedIn website we can move to ODBC DataSources(DSN) Part.<\/p>\n

      \n
    1. Double-click on the ODBC Data Sources App.\n
    2. Click on Add button in User DSN Tab and then select JSON Driver from the driver list and click on Finish button to Create a new JSON Driver.\n
    3. Enter API URL in Properties Tab. Here is the sample Example:\n
      https:\/\/api.linkedin.com\/v1\/people\/~:(id,firstName,lastName,headline,num-connections)?format=json<\/pre>\n
      Select a type of Connection from the Connection drop-down. here for this call, we have to select OAuth Connection.<\/p>\n
      \"ZappySys<\/a>
      ZappySys ODBC JSON Driver: Configurations settings for LinkedIn API<\/p><\/div><\/li>\n
    4. Configure new OAuth Connection for LinkedIn as below.
      \nBasically, you need to enter 3 pieces on the General tab (i.e. ClientId, ClientSecret, Scopes)\u00a0and one more info on the Advanced tab (i.e. callback URL ). If you are not sure what is Scope then check       this LinkedIn API documentation<\/a>. For each API page, you will see which permission needed. Just include the desired scope on ZappySys OAuth Connection (see below).<\/p>\n
    5. After successfully establishing the Connection with LinkedIn, you can Click on Test Connection button.\n
    6. now, let’s go to Preview tab and click on the Preview data\n
    7. And that’s it, Now we will move forward to the next Phase i.e To Load data in Power BI<\/li>\n<\/ol>\n
      Load data into Power BI<\/h2>\n
      In the preview section, we configured and added the ZappySys drivers in the ODBC Driver Administrator with information to connect to LinkedIn REST API. We queried the REST API data in JSON format. Now we will open Power BI and import the information from ODBC.<\/p>\n
        \n
      1. Open Power BI Desktop and select the option\u00a0Get data
        \n<\/strong><\/strong><\/strong><\/p>\n
      2. Get Data will allow adding the ZappySys ODBC driver. Go to\u00a0Other<\/strong>\u00a0and select\u00a0ODBC.
        \n<\/strong><\/strong><\/p>\n
      3. Select ODBC DSN name from the DSN dropdown, and click on OK button for Import data\n
      4. Select data to import and click OK (Below screenshot is for the Table mode import when no SQL specified. You can pick the desired table to import)\n
      5. See the Imported data in table visualization mode. you can select any visualizations as per your need.\n
      6. That’s All \ud83d\ude42 you have successfully imported the LinkedIn data in Power BI dashboard.<\/li>\n<\/ol>\n
        Conclusion<\/span><\/h2>\n
        In this blog, we have learned how to retrieve the basic profile data from LinkedIn using ODBC JSON Driver and then Load those data in Power BI with ODBC DSN in a very simple way. You can achieve many more functionalities with the use of ODBC PowerPack<\/a>. Check our blogs\/articles on <\/b>How to import REST API in Power BI (Load JSON \/ SOAP XML)\u00a0<\/strong>to find out what\u00a0these ODBC Drivers are<\/em>\u00a0capable of more.<\/p>\n
        How to import REST API in Power BI (Load JSON \/ SOAP XML)<\/a><\/p><\/blockquote>\n