Powerquery reference table

[samdthompson]

Hello, I have a table in power query that I reference to make a second table and then delete some columns. No problems. I also want to reference the second table and make a third with a couple of other transformations, again, making it smaller. The interesting thing is that if I reference the second table the memory spikes through the roof and crashes whereas if I reference the origional table then do the transformations it works fine. Anyone come across this sort of problem? Its really wierd, as in my mind, the referencing of the second table to make the third should in theory be the more resource efficient approach. Any ideas?

Cheers,

Sam

[v-yulgu-msft]

Hi @samdthompson,

In my test, I could reference to the second table successfully without any error or warning prompt. Please see below test steps.

For further analysis, please provide more detailed description about how to reproduce your scenario. Also, let me know what transformations you applied to each table. Besides, for "if I reference the second table the memory spikes through the roof and crashes", what error did you get?

Regards,

Yuliana Gu

[samdthompson · Accepted solution]

WIll have to find another way. The PM cant work either as I breached the 60k character limit

[samdthompson]

might be a bit tricky as the M code for the first query is arounf 4k words so i breach the allowable 20k char limit on this message board. I will try messaging you directly