OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

Please can we get this issue sorted as it is very hard to push reports out to many customers when the url has to be hardcoded in order to get around this problem