Download data from Web Page

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