duplicate data from sharepoint

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Office general help » Duplicate Data From Sharepoint Folder Link | Forum

Duplicate Data From Sharepoint Folder Link | Forum

resolvedResolved · Medium Priority · Version 365

Duplicate Data From Sharepoint Folder Link

I have managed to successfully set up a data model that updates based on files in a Sharepoint Document Library, however I am finding that the data is all imported twice.

I presume that this is because it is seeing the Tables as one data source and the Sheets as a second, and so is pulling in both at once.

I have managed to work around it by filtering out Sheet1 in the data table name, but that won't work if it is called something else.

If I was connecting to the workbooks directly it would be easy enough, but as I am just connecting to the folder I can't see a way to do it - Is there an easy way to only pull in the Tables but not the Sheets?

Thanks,
Alex.

RE: Duplicate Data From Sharepoint Folder Link

Sorry wasn't logged in.

RE: Duplicate Data From Sharepoint Folder Link

Ive now resolved this - I added the field 'Kind' when expanding the custom column. This had the option to filter on tables or sheets.

RE: Duplicate Data From Sharepoint Folder Link

Hi Alex,

Thank you for letting us know you've resolved this.

I'll close this item.

Claire

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Microsoft Office tip:

Full Menu Display (Office 2003-2000)

One of the developments in Microsoft Office is that the Menu system has been optimized. This means that only recently used functions are displayed initially when you SINGLE CLICK on the menu.
There are many ways of getting around this:
1. DOUBLE CLICK on the menu bar, it will automatically expand
2. click on the DOUBLE ARROW you see on the bottom of the menu.
3. Wait for the menu to expand

If you always want to have the menus expanded:
4. On the menu bar, click TOOLS, then CUSTOMISE. Select OPTIONS, then uncheck the

View all Microsoft Office hints and tips


Server loaded in 0.07 secs.