automatically the excel data in Power Bi By every Month

[jayendra]

HI

I have a requirment for  every month the excel file name is diferent and data is increasing for every month.But what i have if i created a report in Power Bi  for 1 month and the next month the data is increased and the file name is different with and the file name is like this "SI_Module_MN_Template_Report_06072017" this is for 1 month and the 2 month file name is  like this  SI_Module_MN_Template_Report_06082017. what i want is i dont want to create a  report for the next month.i want is how to generate the report automatically for every month and where i have to store the different excel files to generate the report automatically.

Regards

jayendra

[v-qiuyu-msft · Accepted solution]

Hi @jayendra,

You can put those Excel files into one folder, then in Power BI desktop, get data use Folder data source, use Combine binaries, see : Combine binaries in Power BI Desktop. Next time, you can put the new Excel file in this folder, refresh the report will get new data appended.

Best Regards,
QiuyunYu