Forum Discussion
How to add additional tabs from existing excel spreadsheet data source?
Hi all, I have a excel spreadsheet which has a number of tabs. I am currently using this file as data source for my Power Bi and using 1 of the tabs, however I would now like to also use a f...
All sorted now guys and was able to add the addtional tabs.
The issue was silly - it was a shared document and one of my collegues had it open so would not allow me to access. I didnt realise it was shared so was struggling to understand why it wouldnt work even though I didnt have it open!
There shouldn't be anything stopping you from importing data from another tab, can you screenshot the error?
you should be able to go to Get Data from Excel and select the other tab. Alternatively go to Existing sources and again select the other tab