Forum Discussion
Solved
Import Excel files from Sharepoint and need the worksheet name as a field
Hi, I am trying to import some excel files into PowerBI using PowerQuery and need to have the worksheets of each file as a field in the tables created. I have tried the sharepoint folder method to b...
Managed to solve this using the Web connection method on each spreadsheet in the sharepoint folder and going back some steps in the applied steps on each to get the worksheet name as advised in the steps above.
Tried to do it using the sharepoint folder connection method and inserting step to change the type from contents to data but was unable to get it to work.
Managed to solve this using the Web connection method on each spreadsheet in the sharepoint folder and going back some steps in the applied steps on each to get the worksheet name as advised in the steps above.
Tried to do it using the sharepoint folder connection method and inserting step to change the type from contents to data but was unable to get it to work.