Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic data source refresh with external stored power query m code

Hi all,   We started storing our power query m code inside text files (as Chris Webb explained it here: https://blog.crossjoin.co.uk/2014/02/04/loading-power-query-m-code-from-text-files/) and over...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

That wouldn't be a dynamic source then? Well, I guess "dynamic"  is up for discussion here as you can indeed change the text inside the .pq file. Just make sure all used functions are declared in the environment.

ferryv's avatar
ferryv
Icon for Resolver II rankResolver II
2 years ago

The issue was actually the #shared environment that caused the issue. Even when you hardcoded the url.