Power BI is a business analytics tool from Microsoft that lets you pull in various data sources and turn them into reports and dashboards. You can integrate Power BI with Access LMS Evo, pulling in data as needed.
You will need to be logged in as a super administrator on an Access LMS² site to configure this.
To do this, follow the below steps.
Switch to admin view.
Click Settings then select Global Settings.
Click the Manage Features tab, then click Application Keys.
Click Add OAuth Key, then name the application key Power BI.
Click the secret field, then select all text and copy.
Note that this is your only opportunity to do this. Once closed, you won’t be able to access the pop-up again.
Make a note of the key value and key secret, you will need to enter it at a later stage.
Integrate with report
Switch to admin view.
Click Reporting, then select Quick Reports.
Search for and select the relevant report.
Click Edit Report, then click the Permissions tab.
Enter the OAuth user Key name into the user permissions field.
Change the drop-down to Entity View then click Add.
Power BI
On your Power BI Desktop, click Get Data on the toolbar.
Select Web as the source, then click Connect.
Click Advanced in the From Web window.
For the URL parts enter: https://{SITE}/api/report/get/{REPORTID} in the first box.
Replace SITE with the site name and REPORTID with the GUID that displays in your browser's URL when you run the report in the Access LMS Evo.
Click Add header in the HTTP request header parameters (optional) section.
Add the following two headers.
OAuth key
Authorisation. OAuth followed by the secret.
Click OK and wait for the results to appear.
Click List in the Results row.
Click To Table, then use the default options on the To Table dialog box.
Click the arrows in the header to expand the column and select All Columns.