Creating a Popdock API Endpoint to use with Power BI

Published: Sep 01, 2023

Creating a Popdock API Endpoint to use with Power BI

Published: Sep 01, 2023

This article will guide you through creating a Popdock API endpoint so that you can get the data from a list to Power BI.

How to Add an API Endpoint

1.  From the main menu, select Endpoints.

image 5

2.  Select Click here to add an endpoint.

6307d9d470b361745c758b61 add api endpoint

 

3.  Complete the Add endpoint form with the name for the endpoint, the connector you want to use, the company if needed, and the list you want to use.  In this example, the Business Central connector is being used, along with the Cronus company, and the Sales transaction list.  If you have a favorite saved, you can also select your favorite.  Once you have it completed, select Add.

image 6

The data created for the API endpoint is based on the default fields for a list or the fields you have saved in your Favorite so only those fields will be seen by Power BI.

 

4.  Your API endpoint is now created.  Select the Edit icon and then select API endpoint. You can then select the Copy icon to copy the URL. Now you can go to Power BI to configure the data connection to the endpoint.

image 7

 

5.  In Power BI, select Get Data and then select Web.

6307d9d470b3619c5a758ba8 powerBI get data

 

6.  When the From Web window appears with the option to select Basic or Advanced, you will want to select Advanced. You can then add more information for the connection to Popdock. 

Select the first box under URL parts and paste the API endpoint that you have copied earlier.  At the end of the URL that you pasted make sure it has “?format=csv” or you can manually add it to the end of the URL.  For example, “https://api.popdock.com/api/v1/favorite/Business Central Sales Invoices?format=csv”.

6307d9d470b3619b7a758b72 powerBI advanced

 

7.  In Popdock, select Security from the main menu. Then select API users. Find your API user and then select the Edit icon.

image 9

 

8.  In the left navigation pane, select Tokens. Here you will see tokens that have been created for your Popdock account, select Add token to generate a new token to be used with Power BI.  Enter a description and the user you want to assign the token to.  Select the Copy icon to copy the token.

image 8

 

 9.  Return to Power BI and find the section of the form for HTTP request header parameters (optional).  Select Authorization from the dropdown menu for the first box. Then in the second box type “Bearer ” with a space after it. Paste the token so that it looks like this example “Bearer f1723303-e557-425e-8b3e-a5e2c16ec270”.  Once you have this complete, then select OK.

6307d9d470b36137ba758b27 from web headers

 

12.  When the Access Web content window appears, leave the selection on Anonymous, but make sure the Select which level to apply these settings to dropdown has the full URL selected.  Then select Connect.

6307d9d470b361ed95758bb5 access web content

 

13.  The connection should be successful and the data from the list should show as a table on the load window.

6307d9d470b3619ac8758b89 load data window

 

14.  If everything looks correct, select Load and your data is now available to show in Power BI.

6307d9d470b36159aa758e14 powerBI popdock data 1

Questions on creating API Endpoints for Power BI? Contact support@eonesolutions.com.

Content
How to Add an API Endpoint

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters