It is possible to load all CSV files from a specific folder and union these files to one table?

[amien]

is this possible?

a file contains sales from a day (same format). I tried Get Data|Folder .. but doesn't seem the right feature to do this job?

[WillT]

Yes, you can do this in the Power BI Desktop. The Get Data | Folder option is the one you want, you can then combine the files that get loaded into the Query Editor. There's a good article here: http://devinknightsql.com/2013/08/13/extracting-data-from-multiple-files-with-power-query/
It covers it for Power Query but other than the first step it's the same process 🙂

HTH!