Forum Discussion

thampton's avatar
thampton
Helper III
7 years ago
Solved

Adding sheet from existing onedrive connection

When I originally connected to my one drive (.xlsx) file it had 3 tabs. I have decided to add another tab; How can i edit the data source to capture this additional tab?    Thanks!
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    7 years ago

    thampton duplicate the existing table in power query and go to source step (1st step) and it will show all the tables and sheets, click the new table/sheet you want to add int the model. Thanks!

parry2k's avatar
parry2k
Super User
7 years ago

thampton duplicate the existing table in power query and go to source step (1st step) and it will show all the tables and sheets, click the new table/sheet you want to add int the model. Thanks!