Forum Discussion
sasdfasdfsad
Advocate IV
Advocate IVCross-Report Drillthrough direct query stored procedures?
I have cross-report drillthrough working and it's great. HOWEVER... can I use this with stored procedures or a parameterized TSQL query in Direct Query mode? I want to use the cross report dril...
GilbertQ
Super User
Super UserHi sasdfasdfsad
As far as I am aware, that should be possible as long as you can pass through the value directly through directly to your store procedure.
Here is an example I have that might help Power Query (M) – Passing Parameters dynamically to a SQL Server Query - FourMoo | Power BI | Data Analytics
sasdfasdfsadAdvocate IV
Advocate IVThank you for your help.
I was able to get it to work as expected with the TSQL but I can't get it to pass when calling a stored procedure.
What happens is it doesn't make the stored procedure call foldable.