cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Black_magic100
Helper III
Helper III

Easiest way to gather Bitly click data on a daily/weekly basis

I have 350+ links and would like to know the best way to retrieve the click data for each link. I'd imagine the answer is a REST API, but my knowledge on the topic isn't great and would like to know the best way to integrate this data with power BI
5 REPLIES 5
v-yuezhe-msft
Microsoft
Microsoft

@Black_magic100,

In Power BI Desktop query editor, you can define the Power Query code to connect to Bitly data with REST API. There is an example for your reference.

And you can review the following articles about how to receive Bitly click data with its API.

https://dev.bitly.com/authentication.html
https://dev.bitly.com/link_metrics.html


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I just can not seem to figure it out.  I feel completely lost TBH.  There doesn't seem to be any forum posts that are looking to do the same thing I am doing.

Hi @Black_magic100 ,

 

I figured it out.

 

  1. Create a "New Source" and use the web connector.
  2. Use the basic link option.
  3. Replace the bolded parts with your token and the bitly link. https://api-ssl.bitly.com/v3/link/clicks?access_token=ACCESS_TOKEN&link=LINK
    1. If you don't know what an access token is, check out this link to learn more (https://support.bitly.com/hc/en-us/articles/230647907-How-do-I-find-my-OAuth-access-token-)
  4. That's it!
  5. If you want to pull things besides link clicks, check out this documentation (https://dev.bitly.com/link_metrics.html).

Let me know if you have any more issues.

 

 

The bit.ly upgraded some syntax to v4. Anyone can help me to connect PBI to bit.ly?

Thank you. worked quite well

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors