This article explains how to use a Scope REST Webservice as datasource in Power-BI
Below example is still based on a previous version of our REST Webservices. Please ask our support team for its specifications, if you want to make use of this.
Documentation of the new Scope REST Webservices version 3 can be found on https://riege.github.io/scope-rest-webservices/
Power BI is a technology-driven business intelligence tool provided by Microsoft for analyzing and visualizing raw data to present actionable information. It combines business analytics, data visualization, and best practices that help an organization to make data-driven decisions.
In order to use the data from a Scope REST Webservice as datasource in Power-BI follow the next steps:
1. In Power-BI select the option "Get data from another source"
2. Filter on "Other" and select "Web"
3. Enter the URL for the Scope REST Webservice
This URL differs per Scope customer. Please contact Riege support via https://service.riege.com/en/service_forms/scope-service-request to get access to the Scope REST webservice. You will be provided with:
- URL
- User id
- Password
For accessing masterdata (f.e. partners) the URL will look like:
https:///<your-domain>/rest/v4/partners (for version 4)
For accessing order/shipment the URL will look like:
https:///<your-domain>/rest/v3/orders (for version 3)
The <your-domain>, <ORG> and <BRANCH> varies per Scope customer.
Enter the URL in Power-BI and click OK:
4. Specify user id and password
5. In case of a URL ending with "....orders" you might need to use "transForm Data" to select the lower table "order" in the results.
6. Expand "Order"
This will show the columns of table "order":
See also: https://community.fabric.microsoft.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400
The Scope REST Webservice returns a maximum of 100 orders per query. This means that you will need to create some logic that executes this query using an offset parameter until all the order data is received. You might need to store all the order data in a local database first and use that as a source for Power-BI.