Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Apen
New Member

Create LinkedIn Learning Dashboard using Power BI

Hi Everyone, 

Can somebody help on how to do the cleaning of data from Linkedin Learning using API at Power BI? 

I just need the below data to be shown in the report

1. Top learners - based on number of courses completed and highest number of hours viewed

2. Activation Ratio - how many learners per group activated their accounts

2 REPLIES 2
Anonymous
Not applicable

Hi @Apen 

 

Pls try:

 

Connect to LinkedIn Learning API:

Ensure you have your Client ID and Client Secret from LinkedIn Learning.
Go to Get Data and select the LinkedIn Learning connector.
Enter your Client ID and Client Secret to connect.

 

Load the following tables:
1.For course completions and hours viewed.
2.For activation status.

 

Open Power Query Editor. After loading the data, click on Transform Data.

 

Filter and Clean Data:
Sort the Learner Activity Summary by the number of courses completed and total hours viewed.
Use the Group By feature to aggregate data by learner.

 

Activation Ratio:
From the Learner Summary, calculate the activation ratio by dividing the number of activated accounts by the total number of learners in each group.

 

Create Measures.

 

TopLearners = 
CALCULATE(
    COUNTROWS(LearnerActivity),
    FILTER(LearnerActivity, LearnerActivity[CoursesCompleted] > 0)
)

 

ActivationRatio = 
DIVIDE(
    COUNTROWS(FILTER(LearnerSummary, LearnerSummary[Activated] = TRUE)),
    COUNTROWS(LearnerSummary),
    0
)

 

Create visual objects to present data.

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Kedar_Pande
Super User
Super User

@Apen  
Can you please share LinkedIn Learning using the API link to have a closer look?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors