power query trial balance
Is there a way to create a sql report for trial balance or some other form of report that can be downloaded by excel power query? Eg a website link that could be accessed privately by sending and excel query? It gets very tedious repeatedly downloading trial balances again and again.
3
votes
![](https://secure.gravatar.com/avatar/245b16b8794aa058d42cd5e3a983f861?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Edward Fisher commented
I forgot to say that 36 month trial balances infrequently fail to load
-
Maria Daehn commented
So many times you pick up erros that require changing which means you need to re-export, re-format, re-tweek. If you could "Get Data" from Excel it would be such a time saver