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.
...
Open the provided Power BI file in desktop application and click on Transform data under home tab
| View file | ||
|---|---|---|
|
...
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
...
After making the changes, click on OK button to confirm. Then click on the function
GetConsolidatedReportingDatafrom left menu. Provide the From Date (i.e. 2023-11-01T00:00Z ) and To Date (i.e. 2023-12-01T00:00Z ) and click on Invokebutton, It will authenticate the API in the background and will fetch data.
...