Forum Discussion
Unable to use DIrectQuery in parameterized connection
It seems like your file is already in "Import" mode (and this is indipendent from the fact you are trying to use parameters when connecting to SQL Server). Do you have any other query loaded to the model? Have you tried creating a parametrized connection to SQL Server from a blank file?
Where did you try to apply the parameter? When I tried to filter rows of a DirectQuery even with a constant, I got the error "This step result is not supportted in DirectQuery mode", not to mention using a parameter. So it seems so far not supported.
I've defined 2 parameters and applied them directly in M.
Tried this with new connection with same results
Eric_Zhang, Folding additional operations on top of a custom query isn't supported in DQ mode. You can simply change your custom query to reflect the operation that you are trying to do.
khaox Your scenario is supported. What's the error you are getting?
There is no error message, I'm unable to use direct query mode with parameterized connection (even if it point to the same server and database as before parameterisation).
It seems like your file is already in "Import" mode (and this is indipendent from the fact you are trying to use parameters when connecting to SQL Server). Do you have any other query loaded to the model? Have you tried creating a parametrized connection to SQL Server from a blank file?
