How to Connect Power BI to REST APIs

One of many the reason why Energy BI stands out is as a result of it’s appropriate with many knowledge sources. So, other than conventional knowledge sources like Excel, Textual content, CSV, PDF, JSON and common databases, you may also hook up with REST APIs.

This functionality lets you create studies from an API knowledge of your selection. And since practically all on-line providers have an API that you need to use to retrieve, learn, and replace the info, you need to use this characteristic to create interactive studies and visualizations from common platforms like Jira, Google Sheets, Zendesk, and Google BigQuery, amongst others.

This text introduces you to REST APIs and proceeds for example how one can import the info to Energy BI utilizing REST APIs.

Introduction to REST APIs

A REST API or Representational State Switch Utility Programming Interface is a sort of internet service that enables communication between totally different software program methods over the web. Notably, REST APIs are broadly used to allow the trade of knowledge and performance between internet servers and shoppers.

The first rules and traits of REST APSs embody being stateless, cacheable, uniform interface, layered methods, and the power to have a number of representations. Additionally, you will discover that the REST APIs have sources which are identifiable by URLs or with a number of representations.

REST APIs usually use the usual HTTP strategies to carry out the CRUD (Create, Learn, Replace, Delete) operations on sources:

  • GET: Retrieve the info.
  • POST: Create a brand new useful resource.
  • PUT: Replace an present useful resource or create it if it doesn’t exist.
  • DELETE: Take away a useful resource.

We are able to strive a fundamental REST API instance by sending an HTTP request utilizing the GET methodology to learn the info. You should use the next HTTP request on a browser of your selection:

The results of the HTTP request is as follows:

{“rely”:51,“classes”:[“Animals”,“Anime”,“Anti-Malware”,“Art u0026 Design”,“Authentication u0026 Authorization”,“Blockchain”,“Books”,“Business”,“Calendar”,“Cloud Storage u0026 File Sharing”,“Continuous Integration”,“Cryptocurrency”,“Currency Exchange”,“Data Validation”,“Development”,“Dictionaries”,“Documents u0026 Productivity”,“Email”,“Entertainment”,“Environment”,“Events”,“Finance”,“Food u0026 Drink”,“Games u0026 Comics”,“Geocoding”,“Government”,“Health”,“Jobs”,“Machine Learning”,“Music”,“News”,“Open Data”,“Open Source Projects”,“Patent”,“Personality”,“Phone”,“Photography”,“Programming”,“Science u0026 Math”,“Security”,“Shopping”,“Social”,“Sports u0026 Fitness”,“Test Data”,“Text Analysis”,“Tracking”,“Transportation”,“URL Shorteners”,“Vehicle”,“Video”,“Weather”]}


The subsequent step is to repeat the generated JSON code on a JSON formatter corresponding to It is a free instrument that yow will discover on-line.

Click on on the “Course of” button to generate a brand new code. The code seems like this:

      “Art u0026 Design”,
      “Authentication u0026 Authorization”,
      “Cloud Storage u0026 File Sharing”,
      “Continuous Integration”,
      “Currency Exchange”,
      “Data Validation”,
      “Documents u0026 Productivity”,
      “Food u0026 Drink”,
      “Games u0026 Comics”,
      “Machine Learning”,
      “Open Data”,
      “Open Source Projects”,
      “Science u0026 Math”,
      “Sports u0026 Fitness”,
      “Test Data”,
      “Text Analysis”,
      “URL Shorteners”,


Find out how to Join Energy BI to the Relaxation API Knowledge

Now that you’ve a fundamental understanding of REST APIs, you’ll be able to import the info from EST API to Energy BI utilizing the next course of:

Step 1: Open the Energy BI Desktop and Get the Knowledge

First, open the Energy BI Desktop and get the info by clicking on the “Get knowledge” tab. That is out there on the “Dwelling” tab. Since REST API isn’t one of many out there knowledge sources, you’ll be able to click on on the “Internet” choice on the roll-down menu.

Step 2: Enter Your URL

Enter your API URL. Be certain that you choose the “Primary” choice and enter the identical URL for the HTTP request for the REST API – Then, click on on “OK”. You too can go for the “Superior” choice when you discover it needed.

Step 3: Select the Entry Possibility

A brand new pane will seem with additional choices. This pane offers numerous choices by which you’ll entry the API. You possibly can entry it anonymously by an organizational account or by your Internet API or Home windows credentials.

The given course of opens the Energy Question Editor and consequently hundreds the API knowledge in your Energy BI Desktop as proven within the following:


That helps to attach the REST API knowledge to Energy BI. Now you can use the info to create the Energy BI studies. Word that you may solely create studies for specific classes and the studies can vary from easy playing cards, graphs, charts, to extra advanced maps.

Data: This publish is rewritten with inspiration from the unique URL. Please click on on the supply hyperlink to learn the unique publish

Supply Hyperlink :

Related Articles

Back to top button