How to use all the files in a folder as a source of data for Power BI

Опубликовано: 08 Сентябрь 2026
на канале: Guillermo Diaz Delgado Bragado
1,283
8

Monthly files for the same recurrent information are a nightmare...

How can I report the whole year with that? Let me show you.

I always get the latest values and updates on the project with a monthly spreadsheet, so I have multiple spreadsheet that look the same.

Even worst, every project sends me one of those files every month...

I need to be able to report the status for the whole quarter and year, so I would need to be able to merge all the files into one report.

LinkedIn: https: //www.linkedin.com/in/guillermo-d%C3%ADaz-delgado-bragado-335704100/

Newsletter: https://guillermodazdelgado.substack....

Website: https://bluefado.com/