VBA refer to powerquery connection without loading to table
Would it be possible to access the powerquery connection without loading the data to a listobject?
I was looking at automating an extract of online data, which was in JSON format, this is a hassle in VBA but pretty manageable in powerquery (get & transform).
So I thought maybe I could write a UDF to set up the power query connection, get the data, and output the relevant information. But it seems the only way to "access" the power query data is to load it to a listobject?
It would be really nice if this wasn't a necessary step to access the data.