Forum Discussion
Mart_Ief
6 years agoNew Member
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...
bradsy
6 years agoMicrosoft Employee
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
6 years agoNew Member
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