Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
CheenuSing
Community Champion
Community Champion

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

 

 

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

Proud to be a Datanaut!
Anonymous
Not applicable

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

 

its the connecting these three files thats the tricky one

Hi @Anonymous 

 

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!
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.