Hey everyone,
I’m stuck trying to set up a Power BI dashboard for our company’s LinkedIn page. We want to track stuff like followers, engagement, and how our posts are doing.
I’ve got the app approved on LinkedIn’s dev portal and it’s set up with OAuth 2.0. But I’m not sure how to actually connect Power BI to the LinkedIn Community Management API.
Has anyone done this before? Are there any tutorials or guides out there? I’ve been searching but haven’t found much.
This is holding up a big project at work, so any tips would be awesome. Thanks!
I’ve tackled this challenge before, and it’s certainly not straightforward. One approach that worked well for me was using a third-party tool like Supermetrics. They offer a LinkedIn Ads connector for Power BI that simplifies the process significantly. It handles the API authentication and data retrieval, allowing you to focus on building your dashboard.
If you prefer a DIY solution, consider using Power BI’s Web Data Connector. You’ll need to handle OAuth 2.0 authentication manually, but it gives you more control over the data you pull. Remember to store your access tokens securely and implement a refresh mechanism to keep your data up-to-date.
Whichever route you choose, thoroughly test your solution with a small dataset first to ensure everything works as expected before scaling up.
hey laura, i’ve done this before. it’s a bit of a pain tbh. you’ll need to use power query to build a custom connector. there’s some M code involved for auth and data pulling. watch out for rate limits tho, they’re pretty strict. if you need more help, dm me and i can share some code snippets
I’ve actually gone through this process recently for my company’s marketing team. It can be a bit tricky, but here’s what worked for us:
First, we used a custom connector in Power BI to interface with LinkedIn’s API. You’ll need to create this connector using the Power Query SDK. It involves writing some M code to handle the authentication and data retrieval.
Once that’s set up, you can use Power Query to pull in the data you need. We found it helpful to create separate queries for different metrics like follower count, post engagement, etc.
One gotcha we encountered was rate limiting. LinkedIn’s API has some pretty strict limits, so we had to be careful about how often we refreshed our data.
Also, make sure you’re using the correct API endpoints. LinkedIn’s documentation can be a bit unclear sometimes, so double-check you’re hitting the right URLs.
Hope this helps point you in the right direction. Good luck with your project!