Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Puzzled on Best Way to Model Excel data

Hi Folks,   Thanks in advance for help.   I have the following extract from Workday that I'm loading into Power BI from an Excel file to help do merit planning.   EE ID Name Manager Salar...
Need Help
  • OKgo's avatar
    OKgo
    6 years ago

    Data > Get Data > Folders
    Point at the highest level folder that contains all 60 manager sub-folders

    Complete the sample file wizard to train PQ what the format/headers of the spreadsheet are

    It should look pretty good on import.

     

    I do this all the time for CSV and Excel files and it works great

OKgo's avatar
OKgo
Helper IV
6 years ago

Data > Get Data > Folders
Point at the highest level folder that contains all 60 manager sub-folders

Complete the sample file wizard to train PQ what the format/headers of the spreadsheet are

It should look pretty good on import.

 

I do this all the time for CSV and Excel files and it works great

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Oh...My...God. Is it really that simple? I just tried that. It worked wonders. 

    I was LITERALLY going to sit there and append 50+ docs on top of each other.

     

    You are a genius. Thanks. 🙂

    • OKgo's avatar
      OKgo
      Helper IV
      6 years ago

      Glad it worked and there was not some barrier to stop it