cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jayendra Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: automatically the excel data in Power Bi By every Month

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: automatically the excel data in Power Bi By every Month

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.