Forum Discussion
Power BI LinkedIn API
Hello all,
I wrote in Power BI Desktop a code, where I can access an LinkedIn API anonymously with an access token which I save manually in a parameter. Then I published the dashboard in a workspace and there I wanted to connect the sources, but it was not possible. I can choose the anonymous connection, but I saw no way to add an access token. Is there a way to use an access token for Power BI service to connect to data sources?
Thanks,
Florian
Power BI Desktop:
Power BI service:
Fehler beim Aktualisieren der Datenquellen-Anmeldeinformationen: Web.Contents failed to get contents from 'https://api.linkedin.com/rest/adAnalytics?q=analytics&pivot=CAMPAIGN&timeGranularity=MONTHLY&dateRange=(start:(year:2022,month:1,day:1))&accounts=List(urn%3Ali%3AsponsoredAccount%3A506151752)&fields=externalWebsiteConversions,dateRange,impressions,landingPageClicks,likes,shares,costInLocalCurrency,approximateUniqueImpressions,pivotValues,oneClickLeads,clicks' (400): Bad Request
Hi flo3o ,
You can create a dataflow and then put the code in your screenshot into a blank query.
You can also try to select LinkedIn Learning in the data flow and fill in the corresponding parameters in the corresponding position.
For more details, please refer to the document:
LinkedIn Learning API - First Steps - LinkedIn | Microsoft Learn
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi flo3o ,
You can create a dataflow and then put the code in your screenshot into a blank query.
You can also try to select LinkedIn Learning in the data flow and fill in the corresponding parameters in the corresponding position.
For more details, please refer to the document:
LinkedIn Learning API - First Steps - LinkedIn | Microsoft Learn
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi flo3o were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. I currently use windsor.ai 's Linkedin Ads connector and I haven't had any problem with my data. In case you wonder, to make the connection first search for the Linkedin connector in the data sources list:
After that, just grant access to your Linkedin account using your credentials, then on preview and destination page you will see a preview of your Linkedin fields:
There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
Hi yes the solution from cst worked 🙂
