Best method for using Excel download to build PBI dashboard

[Anonymous]

Hello,

I am looking to build a PowerBI dashboard with data from an Excel file. My challenge is that the data in the Excel file needs manipulation before it can be used in the PBI dashboard. The Excel file is a download from a website and my goal is to be able to download the file daily, save it in the same location with the same file, and refresh the PBI dashboard so it picks up the updated data from the Excel file.

I'm looking for the best method to allow me to do this. Any ideas?

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Your Excel uses the same file and exists in the same location. You can set the gateway and configure the schedule refresh to set the time to automatically refresh according to your needs.

This is the related document, you can view this content:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You can download those in a folder and use folder in power bi and get that merged together 

https://insightsoftware.com/blog/power-bi-load-data-from-folder/