Forum Discussion
AdministratorImport multiple files to PowerBI Desktop
Greetings to all.
I'm new to Powr Bi, I have to perform a data analysis from more than 200 CSV files, and I can't find a way to import them all at once into PowerBI Desktop, how do I do it? I have seen that it is possible to import one by one, but what interests me is to do it in batch, because it is very heavy to go from file to file.
Thanks a lot.
Thank you. From what I have been able to see, so that they do not combine, the import has to be from file to file, there is no way to do it in batches. The truth is that it would be nice to add it as a future feature.
4 Replies
ShahfaisalSolution Sage
Syndicate_AdminThanks for the reply.
The problem is that I do NOT want to combine the files, but to keep them separate, each on its own. Is there a way to do it?
On the other hand, once I get them imported, I want to make queries like "tell me the average of a certain variable for all the months of January, and generate a line graph" (there is one file per month for several years). Is it possible to make these queries in an agile way?
Thank you very much again.
Greetings.
v-yinliw-msftCommunity Support
Hi Syndicate_Admin ,
If your .csv files are in local folder, you can refer this link below, matt's answer may help you.
Solved: Read Multi CSV files and generate PBI reports - Microsoft Power BI Community
If your .csv files are in other location, please tell me to suggest to find another method.
Hope this helps you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Syndicate_Admin
Thank you. From what I have been able to see, so that they do not combine, the import has to be from file to file, there is no way to do it in batches. The truth is that it would be nice to add it as a future feature.