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

In order to get learning data from cloud LMS365 you will need Power BI client for preferred platform and API Secret Key for your tenant (provided by support request). Steps below describe interaction with desktop client.

  1. Using the Power BI desktop client, create a new report.
  2. Select Get Data > OData Feed.
  3. In the OData Feed dialog, in the URL box, enter https://api.365.systems/odata/v2
  4. Access an OData feed modal window will open and display "The user was not authorized" warning. In Basic tab paste API key both in Username and Password fields:
  5. Result:
  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?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.