Skip to end of banner
Go to start of banner

Power BI - Access LMS API Endpoints

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current Restore this Version View Version History

« Previous Version 7 Current »

The following document describes how to access the secured LMS API Endpoints (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

  1. 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 the Home tab

image-20240117-163249.png

  1. 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 open Manage Parameters → Edit Parameters

    image-20240119-094700.png

  2. 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.

  3. 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

image-20240117-164050.png

  1. 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.

image-20240117-164537.png

  1. After making the changes, click on OK button to confirm. Then click the function GetConsolidatedReportingData in the left Queries menu. Provide the ConReportFromDate (i.e. 2023-11-01T00:00Z ) and ConReportToDate (i.e. 2023-12-01T00:00Z ) and click the Invoke button. The function will authenticate and call the API in the background to fetch the data.

image-20240117-165607.png

  1. If you get any popup like this then click on this and select as Anonymous connect. If you don’t, then just ignore this step.

image-20240119-191848.png

  1. Click on Close & Apply (top-left of the window).

image-20240117-165813.png

  1. This will import the data into Power BI and will display the imported data at the right panel where you can select columns for preview. You can later use the data for further processing.

image-20240117-170342.png

Troubleshoot:

If you get any kind of connection error then follow the following steps.

  1. Clear all the permissions. Data Source Settings->Global Permissions->Clear Permissions

image-20240119-192319.png

  1. Follow Step 4 from previous section. (only Step 4)

  2. Open this window and change permission to Anonymous connect for each URL listed here.

222-20240119-191108.png333-20240119-191239.png

  1. Again follow from Step 4 from previous section to fetch the data to process.