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