Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |