Forum Discussion
Right way to refresh data - import Excel
If you have a folder as a source, Power BI picks up all the files in it. You can just save all the exports into the same folder without overwriting the old ones.
So each day/month you can just save new files into the same folder and every time you refresh the query, the new files will be in your query.
If the extracts have the same structure, Power BI automatically appends them when you expand the excel file data in the query editor.
Br,
T
If you have a folder as a source, Power BI picks up all the files in it. You can just save all the exports into the same folder without overwriting the old ones.
So each day/month you can just save new files into the same folder and every time you refresh the query, the new files will be in your query.
If the extracts have the same structure, Power BI automatically appends them when you expand the excel file data in the query editor.
Br,
T
Thanks!