Forum Discussion

khaox's avatar
khaox
Advocate II
10 years ago
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...
Need Help
  • cikuItreti's avatar
    cikuItreti
    10 years ago

    khaox

     

    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?

khaox's avatar
khaox
Advocate II
10 years ago

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).

 

 

cikuItreti's avatar
cikuItreti
New Member
10 years ago

khaox

 

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?

  • khaox's avatar
    khaox
    Advocate II
    10 years ago

    Thanks, Did it from scratch, blank project and direct query works... probably switched by accident