azure datasource causes "unsupported data source for refresh" error

[ibax]

Following datasource connection resolves to an existing Azure SQL Database using a Function to retrieve the specific parameter values. This approach allows a centralized management of the server/database connection values.

Source = Sql.Database( STATIC_ParamGetValue("Model_SQLServer"), STATIC_ParamGetValue("Model_SQLDatabase") )

Within PowerBI Desktop, everything works as expected.

Issue

But after deploying it to PowerBI in the cloud a refresh results in following error: "unsupported data source for refresh"

Workaround

By replacing all Sql.Database statements with static parameter values, refreshing in PowerBI works as expected.

Source = Sql.Database("azureserver.database.windows.net", "databasename")

Request for Improvement

It would be great to be able to use Sql.Database with a value lookup function without causing a refresh error for azure databases. 

[v-haibl-msft]

@ibax

Please create a new idea or vote on existing idea like following one for feature request.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9312540-make-functions-refreshabl...

Best Regards,
Herbert