Forum Discussion
Import monthly data automatically
Hi Anonymous ,
If I understand you correctly, you can save those 12 excel files into one Folder. Then, you can choose Folder as datasource, and combine the files. You can refer to these documents and videos:
Combine files (binaries) in Power BI Desktop;
Power BI: How to Combine Multiple Excel Files from a Folder;
Power BI - Combining Multiple Sheets From Multiple Files in Power Query.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous ,
If I understand you correctly, you can save those 12 excel files into one Folder. Then, you can choose Folder as datasource, and combine the files. You can refer to these documents and videos:
Combine files (binaries) in Power BI Desktop;
Power BI: How to Combine Multiple Excel Files from a Folder;
Power BI - Combining Multiple Sheets From Multiple Files in Power Query.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.