Forum Discussion
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...
Data > Get Data > Folders
Point at the highest level folder that contains all 60 manager sub-foldersComplete 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
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