Status:
Needs Votes
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, an...
This could be really usefull to allow for some collaboration between developers and end-users. Currently, an end-user can't work on the same PBIX file as a developer does event though they are not making conflictual changes. The developer could be implementing complex transformations while the end-user just wants to format some fields, adjust relationships, add new sources. Otherwise, the end-users might end up doing stuff themselves in Power Query without any IT involvement which, if not mentored properly, can lead to erroneous measures and data. Or worse, IT will completely give up power Query to end-users and manage all measures in other data warehouse, cubes or data lakes.
