Multiple excel file to power BI

[Anonymous]

I Have threee excel file

Source file(SAP)

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

cheers

Tj

[CheenuSing]

Hi @Anonymous 

If you want to load multiple excel data files from a folder  follow the link

https://powerbi.tips/2016/06/loading-data-from-folder/

CheenuSing

[Anonymous]

Thats not what i am after i know how to load files 

its the connecting these three files thats the tricky one

[CheenuSing]

Hi @Anonymous 

Please share more details about your problem.

Data files, columns ?  What needs to be connected between the files etc ?

CheenuSing

[Anonymous]

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

thanks