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

duplicate data from sharepoint

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

Duplicate Data From Sharepoint Folder Link

ResolvedVersion 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:

Draw a perfect square or circle

Click on the Rectangle or Oval button on the Drawing toolbar. (If necessary, click Customize on the Tools menu, and then click the Drawing check box on the Toolbars to display the toolbar.)
Press and hold down both the [SHIFT] key and the mouse button.
Drag the mouse pointer diagonally downward and to the right until the rectangle or circle drawn has your preferred measurements.
Release the mouse button.
Release the [SHIFT] key.
In short, simply hold down the SHIFT key while dragging the mouse pointer!

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.