Forum Discussion
Loading Sharepoint Data more efficiently (long refreshes...)
Hi
The main idead behind what you describe is that you only need to get the data from sharepoint once if you only have one source and all the tables are being referenced. On the other hand, if all the tables have a conection with sharepoint (whitout a reference table) you are retrieving all the same data from sharepoint as many times as the number of tables you have. You can do something like this:
Create a files table whit a sharepoint connection whitout any transformation (I pass the sharepoint URL as a parameter)
Then click on the files table an unmark the "Enable Load" option, so that you are not actualy loading this table in the model (This will be your reference table)
Than just reference this table in all the new tables you want to get and do your transformations there.
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Thanks Anonymous! I'll give it a try.
On the same topic, I often get schedule refresh errors that seem like timeouts. They look like this:
with a bit more detail on the browser site:
I have a feeling this happens because I have so many requests going through, have you seen it before?
Cheers!
Never had it, as i only use one connection, and reference my tables from it.
You should try the method i described and see if the errors still come up