Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
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.
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...
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
30 | |
28 | |
23 | |
21 | |
18 |
User | Count |
---|---|
55 | |
37 | |
28 | |
24 | |
21 |