I Have threee excel file
Staging File(Where i convert the currency of the sales data to local currency based on that month rate)
copy this file to the third one which is the dashboard and refresh it and woila!!! its done
now if you can please tell me how can i do that in power bi so that i can just copy the source file and just press refresh and be done with it...
there should be an easy way to do it rather than this
If you want to load multiple excel data files from a folder follow the link
Please share more details about your problem.
Data files, columns ? What needs to be connected between the files etc ?
Alright i hope this should be detailed enough
we get the data from SAP which has 26 column
i paste that to a 2nd file names staging and as a 27 and 28 column i use currency convertion to convert amount into local currency by concatenating some data and vlookup into the conversion rate which is in another sheet
and i copy some of the columns and the converted currency column to another file which has a dashboard
so after copy pasting that data i just refresh it and i get the data i want
so all this step i want to be done easy and convert to excel