Forum Discussion
Parameters in Direct Query
Hello Team, I want to change my local server to on premise server using dataset parameters. I have loaded data using direct query. I could change my server with using parameter in import mode. ...
- 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 there
Currently it is not possible to use parameters with DirectQuery
You can vote for the idea at https://ideas.powerbi.com
Currently it is not possible to use parameters with DirectQuery
You can vote for the idea at https://ideas.powerbi.com
is there any other workaround?