Following The following document describes how to access the secured LMS API Endpoints (Following example is for a CSMART API) using the Power BI Desktop application. In this process, authentication will be completed in the background and is not needed to provide an access token every time while calling APIs.
Instructions
...
Open the provided Power BI file in desktop application (File → Open → Browse this Device → select the .pbix file from disk → click Open) and click on Transform data under home the 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 , select the Home tab and open Manage Parameters → Manage Edit Parameters button
...
...
Change the parameter values according to your environment where you also need to provide
...
the login credentials (user name and password). You only might need to change the parameters marked in the red box.
That will open a new window similar to the following. Now you need to setup the API configuration. For that, select the Home tab and click Manage Parameters
...
Change the parameter values (Current Value) according to your environment where you also need to provide the login credentials (user name and password). You only might need to change the parameters marked in the red box.
...
After making the changes, click on OKbutton to confirm. Then click on the function
GetConsolidatedReportingDatafrom in the left Queries menu. Provide the From Date ConReportFromDate (i.e. 2023-11-01T00:00Z ) and To Date ConReportToDate (i.e. 2023-12-01T00:00Z ) and click on the Invokebutton, It . The function will authenticate and call the API in the background and will to fetch the data.
...
If you get any popup like this then click on this and select as Anonymous connect. If you don’t get any popup like this, then just ignore this step.
...
Click on Close & Apply
...
(top-left of the window).
...
This will import the data in the power into Power BI and will show display 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.
...
.
...
Troubleshoot:
If you get any kind of connection error then follow the following steps.
Clear all the permissions. Data Source Settings->Global Permissions->Clear Permissions
...
Follow Step 4 from previous section. (only Step 4)
Open this window and change permission to Anonymous connect for each URL listed here.
...
Again follow from Step 4 from previous section to fetch the data to process.