How to import the last csv file from a Sharepoint folder

[joobizz]

I'm working on a project where the weekly data source is in csv files.

I left these files in a Sharepoint folder, and filtered to get the last modified from the folder in Power BI, but when I put a new file Power BI understands that they are not in the same format and I have to make the csv adjustments again. Do you know why this happens? The idea is that the update is automatic and I don't have to keep adjusting the new csv file every week.

But now when I filter the last file, it's not separating the columns correctly when I put semicolons in it.

[foodd]

Hello @joobizz , thank you for starting a discussion on the Community Forum. It appears that the issue is not with the file itself, but with identifying the individual or group responsible for overseeing the outbound file format and content of the source data as a Project Stakeholder. This clarification will help minimize the challenges faced and ensure that all data formatting is consistent and agreed upon by all involved parties.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.