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...
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
bradsy
6 years agoMicrosoft Employee
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?