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.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Kudoed Authors