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?
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?
Thanks, Did it from scratch, blank project and direct query works... probably switched by accident