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..
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?
- Hi there
As far as I know there is nothing else at the moment unfortunately.GilbertQ Anonymous Anonymous Anonymous
After lots of research finaly found how to enable parameter in direct query.
follow the following setting in you power bi desktop latest version(June 2020)
File-Option and setting-Preview features-enable-store datasets using enhance metadata.
If it work mark as solution.
Thanks.