Following document describes how LMS API Endpoints (Currently CSMART) can be accessed using Power BI Desktop application. In this process 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 and click on Transform data from home tab.
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 button
Now change the parameters according to your setup where you also need to provide an user’s Id and password who has access to the API. You only might 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.
Add Comment