Following document describes how to access secured LMS API Endpoints (Following example is for a CSMART API) using Power BI Desktop application. In this process authentication will be completed in the background and is not needed to provide access token every time while calling APIs.
Instructions:
Open the provided Power BI file in desktop application and click on Transform data under 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 value according to your environment 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. Then click on the function
GetConsolidatedReportingData
from left menu. Provide the From Date (i.e. 2023-11-01T00:00Z ) and To Date (i.e. 2023-12-01T00:00Z ) and click on Invoke button, It will authenticate the API in the background and will fetch data.
Click on Close & Apply button from left-top.
This will import the data in the power BI and 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.
0 Comments