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
Super User
2 years ago

What is listed in the Data Source dialog?  Just this?

 

https://raw.githubusercontent.com/

 

ferryv's avatar
ferryv
Resolver II
2 years ago

That would be the url to the function you're referencing from github, i.e. a hardcoded url.

  • lbendlin's avatar
    lbendlin
    Super 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
    Resolver II
    2 years ago

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