Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combing thousands of excel files using Power Query. Is my workflow correct?

Hi,    I've built a power query function to extract data from excel files. The excel files are in the same format. The files are stored on a Onedrive folder. I've successfully queried the data usin...
Need Help
  • Jimmy801's avatar
    Jimmy801
    6 years ago

    Hello Anonymous 

     

    exactly, I only added Table.Buffer

    So give it a test and let us know

     

    Jimmy

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Jimmy801 ,

 

Thanks for the follow up. 

 

My code has changed a bit since I last posted, but wanted to confirm that the only change was adding "table.buffer" at the following section:

 

Daily_Data_Entry_Sheet = Table.Buffer(Source{[Item="Daily_Data_Entry",Kind="Sheet"]}[Data]),

 

if so, i can test it on my current query function.

 

Thanks again,

 

Tony

Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
6 years ago

Hello Anonymous 

 

exactly, I only added Table.Buffer

So give it a test and let us know

 

Jimmy