cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tjemson Frequent Visitor
Frequent Visitor

Multiple excel file to power BI

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

 

4 REPLIES 4
Super User
Super User

Re: Multiple excel file to power BI

Hi @tjemson 

 

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

 

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
tjemson Frequent Visitor
Frequent Visitor

Re: Multiple excel file to power BI

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

 

its the connecting these three files thats the tricky one

Super User
Super User

Re: Multiple excel file to power BI

Hi @tjemson 

 

Please share more details about your problem.

 

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

 

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
tjemson Frequent Visitor
Frequent Visitor

Re: Multiple excel file to power BI

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