Forum Discussion
Data Refresh
Yes our product stock inventory is hosted on a website and the data from that can then be exported into a CSV file. Meaning that I have to manually export a CSV file everyday to get the latest data. And yes these CSV files all have a different name, with the date and timestamp that it was created in the name.
Okay, I see 2 options, one a short term workaround, and the other one as a long term solution:
1) Short-term: When you export the file, save it with a specific naming convention on a cloud-based location (Sharepoint/OneDrive/Google Drive). You will always name it this way on a daily basis. Since it will have the same name, the last file would be replaced/overwritten. Your Power BI report will have no issue because it will always read the file with the same name.
You can reduce some manual steps here if you develop some small automation in Power Automate to do the file saving process, but this solution will always inherently be manual because it requires for you to extract data manually.
2) The long-term solution is you finding a way to connect to the web page (or the database/data sources) behind it. The nature of this will depend on the architecture of the web page. By setting up a direct connection you avoid exporting manually the data. As to how to achieve this, my answer is, it depends on how is the data behind the web page structured/located.