Power BI logo

Integration between Ongoing WMS and Microsoft Power BI

First one needs to set up a API user for the goods owner you want to get the data from. See API access on how this is done.

Next open your Power BI Desktop application. Navigate to the the Home and under the Get data menu, click on Web. In the window that has appeared select Advanced.

In this menu you will need to fill out the data you want to extract. As an example, we are intrested in extracting the data of all orders that has been sent for a specific goods owner. Then the menu in Power BI would look something as the image below.

The first fields consitutes the url you want to fetch your data from. In the HTTP fields enter Authorization in the left field and "Basic " + Base64Encode(userame:pwd), in the same way described in REST API under Authentication.