Forum Discussion
Anupa_Jayakody
Helper I
Helper IRefresh+ 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??
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.
Anupa_JayakodyI 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]