Following document describes how LMS API Endpoints (Currently CSMART) can be accessed using Power BI Desktop application. Here authentication will be completed in the background. You don’t need to provide access token every time while calling APIs.
Open the provided Power BI file in desktop application.
Click on Transform data from home table.
...
That will open a new window similar to the following.
...
Now you need to setup the API configuration. For that click on the Manage Parameters → Manage Parameters
...
Now change the parameters according to your setup. Where you need to provide an user’s Id and Pass who has access to the API. You only need to change the parameters marked in the red box.
After making the changes, click on OK button to confirm the changes. The click on the function from left menu. Provide the From Date and To Date and click on invoke button, It will authenticate the API in the background and will fetch data.
Click on Close & Apply button
...
It will import the data in the power BI and it will show the imported data at the right panel where you can select columns for preview. You can later use the data for further processing as you want.
