Forum Discussion
Solved
Unable 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_databas...
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