Forum Discussion

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
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!

2 Replies

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!
v-danhe-msft
Microsoft Employee
7 years ago
Hi thampton,

Could you used below link to connect your data?

https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links

If so, the connection mode is import and you could just click "Get Data" to connect different data in Power BI:

Regards,

Daniel He

Forum Discussion

Adding sheet from existing onedrive connection

2 Replies

Related content

Synchronize existing items with OneDrive items

OneDrive Refresh

Error connection to Excel file on OneDrive

We need assistance to detach/remove the existing OneDrive

Linking to SharePoint, NOT OneDrive