I am currently trying to pull data from our organizations Linkedin Learning Enterprise. After talking with our rep, she recommended reading the following and trying to build an API in LinkedIn Learning and then connect it:
https://docs.microsoft.com/en-us/linkedin/learning/integrations/learning-activity-reports
https://www.linkedin.com/help/learning/answer/113380
Using the first link I was able to create an API in our account, but I'm not super clear on next steps. I have a user and a key that linkedin generated, but no url or anything else. I'm not sure how to specify what data to pull and how to pull it into Power BI.
Has anybody tried to connect LinkedIn Learning and Power BI in the past? Alternatively, does anyone have any tips on API building and pulling in Power BI? A lot of the documentation I've found has been confusing as a non-IT data professional.
I'm not pretty sure but it looks like you need to use Get Dat -> web and then input url from your https://docs.microsoft.com/en-us/linkedin/learning/integrations/learning-activity-reports link:
https://api.linkedin.com/v2/learningActivityReports?q=criteria&contentSource=EXTERNAL&timeOffset.unit=DAY&aggregationCriteria.primary=CONTENT&start=1&count=1&assetType=COURSE&startedAt=1552652108993&=&sortBy.engagementMetricQualifier=TOTAL&timeOffset.duration=1&sortBy.engagementMetricType=SECONDS_VIEWED
then you will be redirected to auth form in power bi
User | Count |
---|---|
450 | |
208 | |
119 | |
59 | |
57 |
User | Count |
---|---|
477 | |
265 | |
151 | |
81 | |
78 |