Importing data via Power BI

Document created by Peachy Velasco on Sep 25, 2017Last modified by Peachy Velasco on Jan 28, 2020
Version 14Show Document
  • View in full screen mode

You can use the Microsoft Power BI desktop to extract data and import it to Power BI Desktop for manipulation.

Note: Before you can import data via Power BI, you must first enable this feature. See Connecting to the API to extract data

Importing Data via Power BI

To extract data using Power BI.

  1. Launch the Power BI Desktop.
  2. From the Home ribbon, click Get Data. This opens a list of data types/sources.
  3. Select All, scroll down and locate Web and then click Connect.

WebPowerBI.png

  1. In the dialog box that appears, select Advanced.

PowerBI.png

a) In the URL parts, paste the URL part of the HTTP request.

Example: https://api.beacon.pharos.com/ReportApi/Reports/PrintJobs/2017-04-01/2017-05-01 

Example: https://api.beacon.pharos.com/ReportApi/Reports/MonthlyPrintJobs/2017-04/2017-05

b) Enter the HTTP request header parameters.

  • In the first field, select Authorization from the drop-down list box.
  • In the second field, type in bearer and then paste the Authorization Key.

  1. Click OK. After connecting to the Beacon server, you will see the extracted data.

Attachments

    Outcomes