Create a Power BI report with LMS365 (Learn365) cloud data using the OData service v4

To create reports on the learning data from LMS365 (Learn365), you will need Power BI client for preferred platform and the API secret key for your tenant. This articles describes the steps of how to get an API key and how start creating reports in your Power BI desktop.


In this article


Get the API key for the Power BI

To get the API key for your tenant domain, the Microsoft 365 global administrator or LMS administrator should do the following:

1. Navigate to Learn365 Admin Center > Global Settings > Settings > API Key Management.

2. Select the relevant API key from the list of API keys and chose the Copy API Key option next to the key to copy the API key to clipboard. 




Connect LMS365 (Learn365) with Power BI desktop

Steps below describe interaction with desktop client:

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

2. Select Get Data option > OData Feed.




3. In the OData Feed dialog, in the URL box, enter 




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

Region API End Point
Central US
North Europe
Japan East
Australia East
Canada Central
United Kingdom South
Germany West Central
U.S. Government GCC


4. Access an OData feed modal window will open and display "The user was not authorized" warning. Navigate to the Basic tab:

  • In the Username field paste the copied API key or enter the word api.
  • In the Password field also paste the copied API key.
  • Select Connect to continue.



5. After the connection is installed, you will see a left-side menu with a list of tables that you can select to use for your visualizations. From here you can start building your visualized reports.





You may be interested in this tutorial: Analyze sales data from Excel and an OData feed

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


Was this article helpful?
22 out of 36 found this helpful


Article is closed for comments.