Showing results for 
Search instead for 
Did you mean: 
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


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.


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.
    1. If you don't know what an access token is, check out this link to learn more (
  4. That's it!
  5. If you want to pull things besides link clicks, check out this documentation (

Let me know if you have any more issues.



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

Thank you. worked quite well

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors