Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Friends,
I am using one Direct Query in my Report for example :
select * from Invoice_master where Invoice_no = 'Inv101'
I want to use parameter in my Direct Query intead of Invoice_no='Inv101'
I tried query parameter but not success
I had created one more data set with distinct Invoice_no and then created parameter using query in this parameter,
I also changed the Mquery of this report and removed the hard coded Invoice_no='Inv101' and Placed Invoice_no='"&Inv&"'
but the report is showing only the data of given default value in parameter and it's not changing into Direct Query
Thanks
Kamal
kamal.maru@yahoo.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.