Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |