February 24, 2021
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?