Forum Discussion

Mart_Ief's avatar
Mart_Ief
New Member
6 years ago

Error using parameters in datasource with Direct Query in update May 2020

We're getting errors using parameters in the datasource together with Direct Query in the May 2020 update. Even if we just connect to one SQL Server table with parameters for server and database, af...
Direct Query
may 2020
parameters
d_gosbell's avatar
d_gosbell
Super User
6 years ago

bradsy are you aware of any issues in this area of parameters and Direct Query?

bradsy's avatar
bradsy
Microsoft Employee
6 years ago

I have not heard any problems similar to this. If you can detail the repro a little better, we can give it a try to see if we can replicate the issue.

  • Mart_Ief's avatar
    Mart_Ief
    New Member
    6 years ago

    Thank you for responding.

    I'll illustrate with a few screenshots...all in DirectQuery mode:

     

    First with hardcoded server and database

    after close and apply the connection is evaluated correctly.

    Then with parameters 'ServerName' and 'DatabaseName'

    after close and apply the next message appears during connection evaluation...

    Allow parameterization in datasource is on.

    Up till now this worked fine and as I said used all over production.

    gr.

    Martin

    • bradsy's avatar
      bradsy
      Microsoft Employee
      6 years ago

      Hi Mart_lef,

       

      I was not able to reproduce. The parameters were applied and my dataset kept working with DQ. Any other users seeing this?