Download data from Web Page

[swetadutta7]

Hello all, is there a step by step guide to be able to read reports from a company web page please. Gone through multiple documents/videos online but still haven't been able to fig it out.

[burakkaragoz]

Hi @swetadutta7 ,

Thanks for sharing the details. I totally get how frustrating it can be when you’ve already tried docs and videos but still can’t get it working.

To help you better, could you maybe clarify a few things?

• Is the company web page you're referring to publicly accessible or does it require login?
• Are you trying to just view the reports or download the data behind them?
• Do you need this to be automated or is it a one-time thing?
• Do you have access to any API or credentials for that site?

Once I have a bit more context, I can guide you through the steps more precisely. There are a few different ways to approach this depending on how the site is structured and what kind of access you have.

Let me know and we’ll figure it out together.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[swetadutta7]

Hi, many thanks for the reply..here's few more details that might be useful to mention

- Yes, it is a company web page, requires login id and password to access

- This website has few inbuilt reports, so just trying to download one of them that I can then load it into a fabric lakehouse table using dataflow.

- Need this to be automated, a daily feed

- Unfortunately no API details and the support team take forever to reply back so if absolutely necessary then will go down that route. But, currently I am exploring direct web page access or SFTP file transfer process.

Might be worth mentioning that I have only started using Microsoft Fabric dataflow last week, so everything is fairly new to me 🙂 

[v-lgarikapat]

Hi @swetadutta7 ,

Thanks for the details .

Based on the details you provided, here are a few workarounds to download the automated report and move it to Fabric using Dataflow.

Headless browser automation

Use a tool like Power Automate Desktop

1. Log into the website with saved credentials.
2. Navigate to the desired report.
3. Trigger the download on a schedule (daily).
4. Save the file (CSV, Excel, etc.) to a local folder or shared drive.

 SFTP (if the site has it)

If you can convince the team to expose the report via SFTP, that’s a smoother integration. You can use Power Automate or Python scripts to grab the file daily.

Move File into Microsoft Fabric

Once you’ve got the file, here's how to get it into your Fabric Lakehouse via Dataflow Gen2:

1. Go to Dataflows Gen2 in Microsoft Fabric.
2. Create a new dataflow and select your source (Excel, CSV, etc.).
3. Point to the file location (OneDrive, SharePoint, local folder via gateway, etc.).
4. Use Power Query to transform it as needed.
5. Choose your destination as a Lakehouse table.
6. Set the refresh schedule to daily.
7. If you go with headless browser automation, Power Automate Desktop is beginner-friendly and integrates well with Microsoft 365 tools.
8. You can test your flow manually first to make sure the download and load steps work before scheduling it.

Create your first Microsoft Fabric dataflow - Microsoft Fabric | Microsoft Learn

If this post helped resolve your issue, please consider the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana

[v-lgarikapat]

Hi @swetadutta7 ,

Thanks for reaching out to the Microsoft fabric community forum.

 You're trying to figure out how to read or pull reports from a company’s website, but it’s been tricky with all the info out there. I’d love to help you out just need a few details to make sure I point you in the right direction.

Could you let me know

• Is the website public, or do you need to log in to access the reports?
• What kind of reports are you trying to view like PDFs, Excel files, tables, charts?
• When you say read, do you mean just looking at them, downloading, or maybe extracting the data?
• Are you hoping to automate this somehow, like pulling the data into Power BI, Excel, or using a script?
• Do you have access to things like login credentials, admin rights, or an API (if available)?
• What have you already tried so far, any tools, scripts, or tutorials?

Looking forward to your response.

Best regards,
LakshmiNarayana

[swetadutta7]

Hi, 

I have replied to one of the previous post with some necessary details, hopefully will be sufficient to give a picture of what I am after 🙂