Forum

Remote connect to S...
 
Notifications
Clear all

Remote connect to SharePoint data model?

2 Posts
2 Users
0 Reactions
159 Views
(@bunneh68)
Posts: 4
Active Member
Topic starter
 

I am running lots of data cleanses in a set of power queries and then passing these to analysis in another set of power queries. I do this by outputting the cleanses into tables, saving these to SharePoint and then linking to that sheet through File/ Info/ Copy path. I know this is very inefficient but I want to retain the online links and can’t think of, or have discovered, anything better. Can anyone recommend a better method?

 
Posted : 01/08/2021 3:37 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Simon,

What do you mean by "and then linking to that sheet through File/ Info/ Copy path"? Are you linking to the data using formulas?

Mynda

 
Posted : 05/08/2021 7:49 pm
Share: