Forum Discussion

MichaelJ64's avatar
MichaelJ64
Frequent Visitor
5 years ago

Troubleshooting - calculate only current step

Hello community,   Is it possible to tell the power query editor to only recalculate the current step?  I am finessing my code and at the moment when I test, it (seems to) fetch my data again.  I d...
Need Help
Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

Hello MichaelJ64 

 

when you loaded data of a query into BI and you don't want that this data is reloaded, unflag the "enable load"

Copy paste this code to the advanced editor in a new blank query to see how the solution works.


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

MichaelJ64's avatar
MichaelJ64
Frequent Visitor
5 years ago

Hi Jimmy,

 

Thanks for your help.  I had a go with your approach but sadly it hasn't helped.

I also ran into the problem with Table.AddIndexColumn wandering off into another dimension. I have programmed around this one.

 

Michael J.

 

P.S.  Thank you for your prompt response and I apologise rudeness in being so slow to acknowledge your help.