Forum Discussion

jayendra's avatar
jayendra
Frequent Visitor
9 years ago
Solved

automatically the excel data in Power Bi By every Month

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

Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    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