How to create Power BI report with LMS365 cloud data, using the OData service v4

In order to get learning data from cloud LMS365, you will need Power BI client for preferred platform and the API secret key for your tenant. 

To get the API key for your tenant domain e.g. elearningforce.sharepoint.com, the Office 365 Global Administrator should navigate to LMS365 Admin Center – Global Settings – Settings – LMS Configuration – API key management and copy the API key.

 

2020-05-29_16-28-04.png

Steps below describe interaction with desktop client.

1. Using the Power BI desktop client, create a new report.

2. Select Get Data > OData Feed.

 

1.png

 

3. In the OData Feed dialog, in the URL box, enter https://api.365.systems/odata/v2 


2.png

NOTE   

We recommend using specific LMS365 API end point for your region to eliminate any possible issues with proxy. Here is the full list:

Region API End Point
Central US https://us-api.365.systems/odata/v2
North Europe https://ne-api.365.systems/odata/v2
Japan East https://je-api.365.systems/odata/v2
Australia East https://au-api.365.systems/odata/v2
Canada Central https://ca-api.365.systems/odata/v2
United Kingdom South https://uk-api.365.systems/odata/v2
Germany West Central https://de-api.365.systems/odata/v2
U.S. Government GCC    https://va-api.usgcc365.systems/odata/v2

 

4. Access an OData feed modal window will open and display "The user was not authorized" warning. In Basic tab, paste

  • The API key or enter the word api into the Username field.
  • The API key into the Password field: 

mceclip0.png

5. Result:

 

4.png

6. Select the tables that you want to use for your visualizations. 

7. Go on building visualizations as needed.

TIP: You may be interested in this tutorial

TIP2: For more technical details about OData service provided, please check the document attached.

Was this article helpful?
16 out of 26 found this helpful

Comments

Article is closed for comments.