Forum Discussion
Daily and Weekly Sales Activity Updates
Hi djr001
#1.
You can add current date filter on power query to only display current date records, but power bi not contains any feature to auto split and export data from power bi.
Power Query Current Date Filter
1.1. If these excel files same stored with same structure in different files, you can move them to one folder and try to get data from that folder. After get data, you can simple expand and merge them to one table.
1.2. I' not familiar with flow procedure, you can submit this to related forum to get further support.
#2.
After add dynamic date filter, it will only display specific period based on current date. You not need to replace report manually.
#3.
Please refer to below link to know how to get diff from DOD period.
#4.
After create and publish power bi reports, you can try to use power bi subscribe feature or microsoft flow to control and send email of these reports at particular date period.
Subscribe to a Power BI report or dashboard
Regards,
Xiaoxin Sheng
Hi djr001
#1.
You can add current date filter on power query to only display current date records, but power bi not contains any feature to auto split and export data from power bi.
Power Query Current Date Filter
1.1. If these excel files same stored with same structure in different files, you can move them to one folder and try to get data from that folder. After get data, you can simple expand and merge them to one table.
1.2. I' not familiar with flow procedure, you can submit this to related forum to get further support.
#2.
After add dynamic date filter, it will only display specific period based on current date. You not need to replace report manually.
#3.
Please refer to below link to know how to get diff from DOD period.
#4.
After create and publish power bi reports, you can try to use power bi subscribe feature or microsoft flow to control and send email of these reports at particular date period.
Subscribe to a Power BI report or dashboard
Regards,
Xiaoxin Sheng