Forum Discussion
Advocate IIUnable to use DIrectQuery in parameterized connection
I've created Azure SQL connection with parameters, it make unable to use directQuery
Doesn't work neither with UI defined connection nor with M script "= Sql.Database(PowerBI_server, PowerBI_database)"
At time of defining connection both parameters where pointing to live and accessible Azure database
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?
6 Replies
Eric_ZhangMicrosoft Employee
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.
khaoxI've defined 2 parameters and applied them directly in M.
Tried this with new connection with same results
- pqian
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?
- khaox
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).