Support refresh from the web when running code/script (Power Query, SQL, R...) from a text file
When you deploy multiple dashboards that use the same script/code (whether it data transformation in Power Query (M), a SQL statement or an R code), it is efficient to put one code in a text file, and query against the file, rather then copy/pasting the code every time you make a change.
Here is an example of a workaround: https://blog.crossjoin.co.uk/2014/02/04/loading-power-query-m-code-from-text-files/
The problem is that now you can't schedule a refresh from the web: Power BI throws an error
"You can't schedule refresh for this dataset because one or more sources currently don't support refresh."
Can you make such approach acceptable and support scheduled refresh?
Cristian Avendaño commented
This is something we need.. It's a paint to copy the code and mantain the same version of the code.
I actually store my codes in OneDrive for Business, but I point Power BI to the web link, not the folder on the hard drive. But that doesn't matter: the main idea is to let Power BI consume the code from the text file, whether hosted on disk, on the cloud or anywhere else.
Amadeusz Wieczorek commented
My team is sharing queries on git (for sharing and peer reviews) and we would also really like to load them from disk. Currently on each change we need to manually go to Advanced Editor and paste the updated query