To create reports on the learning data from 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 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 https://api.365.systems/odata/v2
NOTE
We recommend using specific 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 | 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. 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.
TIP
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.
Comments
Article is closed for comments.