Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sasdfasdfsad
Helper II
Helper II

Cross-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 drillthrough feature and pass an account ID, but I want my target report to take that Account ID and pass it to the stored procedure to run it in Direct Query Mode.

So I have a normal PBI report with a list of Account IDs, then someone can click on one, Drill Through -->  pick the cross report drill through and then pass that Account ID along so the targer report runs the stored procedure and returns the data for that Account ID.

Is that possible?

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @sasdfasdfsad 

 

Yeah as far as I know when using a stored procedure it does not query fold as expected. You might have to use the TSQL to get this working.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @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 A...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thank 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.


Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors