Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
rabeeh
Regular Visitor

NEED TO EXTRACT DATA FROM WEBSITE INTO EXCEL /CSV

I WANT TO USE THE DATA FROM https://www.messivsronaldo.app/match-histories/ronaldo-match-history/ HOW I WILL GET THE DATA IN TABLE FORMAT TO USE IN POWER BI REPORT.

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @rabeeh -you'll need to scrape or manually export the data into a structured format like a CSV or Excel file for use in Power BI. Since there’s no built-in option to directly download the data.Copy the match history data and performance stats directly from the page.Paste the data into an Excel spreadsheet.Format the table columns to match the data you need (e.g., Date, Match, Goals, Assists).

Suppose, as this is sports statistic websites if there is any API for developers to pull live or historical data. You can check if the site has any API access for this type of data extraction, which can feed directly into Power BI.

 

Hope the above information helps.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Hi @rabeeh -you'll need to scrape or manually export the data into a structured format like a CSV or Excel file for use in Power BI. Since there’s no built-in option to directly download the data.Copy the match history data and performance stats directly from the page.Paste the data into an Excel spreadsheet.Format the table columns to match the data you need (e.g., Date, Match, Goals, Assists).

Suppose, as this is sports statistic websites if there is any API for developers to pull live or historical data. You can check if the site has any API access for this type of data extraction, which can feed directly into Power BI.

 

Hope the above information helps.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.