I have many folders and subfolders sortered by years and month in a S3 bucket, and in each month subfolder there a file csv.
For example, this are the paths in the same bucket:
folder 1---> format=v1/country=ni/year=2023/month=07/business_unit=mobile/filemonth07.csv
folder 2---> format=v1/country=ni/year=2023/month=08/business_unit=mobile/filemonth08.csv
folder 3---> format=v1/country=ni/year=2023/month=09/business_unit=mobile/filemonth09.csv
I want to connect and import all these files into Power BI. How can I make this?
I know there are other articles that send me to other links to see the solutions, but they really end up being just theories.
Please guide me with the step by step right here. Whatever the solution is
- If there is a python script to be made, please help me to create the script and put it here.
- If there is another way, please explain it to me as well.
Thank you very much in advance.
This is my linkedIn if you wan to be in contact with me:
https://www.linkedin.com/in/nestor-reyes-ni/
