Forum Discussion

swetadutta7's avatar
swetadutta7
Regular Visitor
1 year ago
Solved

Download data from Web Page

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.
CICD
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    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's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
1 year ago

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's avatar
swetadutta7
Regular Visitor
1 year ago

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 🙂