Forum Discussion
Parameters in Direct Query
- Hi there
As far as I know there is nothing else at the moment unfortunately. Yes by using rest api you can update parametrs in direct query.
Step 1- Take direct query mode and in advance option write a normal query.
Step 2- Go to adavance editor and change that query with parameter.
like
let
Source = Sql.Database("host name", "database_name",
[Query="select * from [schema name].["& paramter 1 & "_retailername_"& paramter2 &"] (NOLOCK)"])
in
SourceIn the above example i chnage my direct query using parameter.
If you want to chnage thease parameters using powershell plz follow the following link-
If i answer your question marked as solved..
Hi Anonymous
Is the SQL Server On-Prem or Azure?
Are you using any gateways?
Anonymous Sql server not using any gateway.
Direct query with parameters only support sql server as data source.
if i answer your question mark as solved.
Thanks.