Run CricAPI IPL APIs in Power BI in 2 Minutes — No Code Needed!
Want to create a live IPL dashboard in Power BI? You’re in luck! In this quick tutorial, we’ll show you how to connect CricAPI directly in Power BI using the built-in Web connector — no coding required.
Whether you’re tracking live scores, points tables, or match schedules, this method is easy for beginners and fast for pros.
CricAPI URLs You’ll Need
Replace
"YOURKEY"with your actual API key from CricAPI.
Live Match Scores
https://api.cricapi.com/v1/cricScore?apikey=YOURKEYhttps://api.cricapi.com/v1/cricScore?apikey=YOURKEYhttps://api.cricapi.com/v1/cricScore?apikey=YOURKEY
IPL Points Table
https://api.cricapi.com/v1/series_points?apikey=YOURKEY&id=d5a498c8-7596-4b93-8ab0-e0efc3345312https://api.cricapi.com/v1/series_points?apikey=YOURKEY&id=d5a498c8-7596-4b93-8ab0-e0efc3345312https://api.cricapi.com/v1/series_points?apikey=YOURKEY&id=d5a498c8-7596-4b93-8ab0-e0efc3345312
IPL Series Info
https://api.cricapi.com/v1/series_info?apikey=3YOURKEY&id=d5a498c8-7596-4b93-8ab0-e0efc3345312https://api.cricapi.com/v1/series_info?apikey=3YOURKEY&id=d5a498c8-7596-4b93-8ab0-e0efc3345312https://api.cricapi.com/v1/series_info?apikey=3YOURKEY&id=d5a498c8-7596-4b93-8ab0-e0efc3345312
Note :
The ID d5a498c8-7596-4b93-8ab0-e0efc3345312 is for IPL 2025.
If you want to view details of any other series or tournament, you can simply replace the tournament ID in the API URL. You can find the ID of any series on CricAPI and use it like this:
https://api.cricapi.com/v1/series_info?apikey=YOURKEY&id=TOURNAMENT_ID
For example:id = d5a498c8-7596-4b93-8ab0-e0efc3345312 → for IPL 2025id = TOURNAMENT_ID → Replace this with the ID of any other tournament.
Just update the id parameter to load data for different tournaments in Power BI.
Steps to Load the API in Power BI
Step 1: Open Power BI Desktop
Launch Power BI
Click on Home > Get Data > Web
Step 2: Paste the API URL
Choose Basic option
Paste one of the URLs above
Click OK
Power BI will connect to the API and return the JSON data.
Step 3: Navigate the Data
In the Navigator pane, select the
datafieldIf it’s a list, click Convert to Table
Then click To Table > Expand Columns as needed
Repeat for the other two APIs.
What You Can Build
| Visual | Source API |
|---|---|
| Live Match Card | cricScore |
| Points Table | series_points |
| Match Schedule | series_info |
Tips for Using the Data
Rename the queries:
LiveScores,PointsTable, andMatchScheduleAdd visuals like tables, cards, and slicers
Set up auto-refresh if publishing to Power BI Service
Benefits of This Method
No coding needed
Quick and efficient
100% API-based data refresh
Great for dashboards or reports during IPL season
Final Words
With CricAPI and Power BI, you can impress your friends, followers, or clients with real-time IPL data dashboards — all without writing a single line of code.
If you want a ready-made Power BI file Click Here to View!
