Forum Discussion
Refresh+ append together
I have daily data coming in.
How can i schedule a refresh daily so it picks up the new file and append to the old file and then refresh??
2 Replies
Hello,
I think I have the solution to your question. Check this link:Automatically update data according to the date in... - Microsoft Power BI Community
it should solve your problem.
Let me know how it goes.I get this error when i try to combine the files and load,
An error occurred in the ‘Transform File’ query. Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=Late_1Nov2022
Kind=Table
Table=[Table]
