Power BI for LMS365 learning data

In order to get learning data from cloud LMS365, you could use either connector for Microsoft products like Logic Apps, Power Automate, and Power Apps or OData web services directly. For Power BI, you could use OData with API Secret Key for your tenant. The steps have been described in details by Microsoft. There are few tips you should be aware of.

1. You need to get the API Secret Key for your tenant from the support before you can use the API.
2. The user name normally is “api”
3. After connected to LMS365 through OData, you should not import all tables. You will get an error when you importing all tables.
4. Normally you only need the following enties.

• Course Catalog
• Course
• User
• Enrollment
• Assignment
• SCORM
• SCORM Statuses
• Quiz User Statuses
• Learning Module User Statuses

You should set up the refresh schedule using the same OData credential. The example of the report is below.