Connecting Power BI to LinkedIn Learning

[Anonymous]

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://help.linkedin.com/cc/custom_fattach/get/10010155/0/filename/LinkedIn%20Learning%20Reporting%...

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. 

[adelheni]

Hi, so the solution above while it's true, it's not totally efficient, because there is call limits to any API URl.
What i would suggest to connect Linkedin  to Power bi, is to use a third-party connector such as windsor.ai.
It's pretty easy to set up, and you can choose from +200 metrics and dimensions.

[az38]

Hi @Anonymous 

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