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
WheresWally
Helper III
Helper III

Paginated reports have a Drillthrough limit - how do I increase it please?

Hi, 

 

I'm using drillthrough links to the same report with different parameters. After clicking 4 of those, the 5th gives me this message:

 

"Drillthough limit exceeded" "Exceeded the number of drillthrough actions for the report. Your report exceeds the maxiumum of 4 for drillthrough actions. Please contact the report author to reduce them and try again. "

 

I haven't set a limit. I don't know where to increase the limit. I have searched within the report settings/code and the Power BI admin settings, workspace settings, report management etc. to no avail. I have googled the message and it seems nobody has reported this before. With drillthrough being so new to the PowerBI service paginated reporting, is this a hidden (unannounced/undocumented) limit that I've discovered?? Is there any way to increase it?

 

Thanks

WheresWally_0-1689559254572.png

 

2 REPLIES 2
rubayatyasmin
Super User
Super User

Hi, @WheresWally 

Power BI doesn't allow more than 4 Drill-through because of performance surety and manageability. 

 

you can create drill-through button as a solution. 
How ever this post my be helpful for you. https://community.fabric.microsoft.com/t5/Desktop/Drill-through-Limitation-in-Power-BI/td-p/1571992

 

If my assistance helped you in any way, hit 👍.

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Hi @rubayatyasmin

 

thanks for your reply. 

 

The link you sent is from 2020 when drillthrough in paginated reports had not yet been released. It looks to be referring to drillthrough in regular pbix reports. 

 

Regarding performance, reloading the same report via a manual click on a link in that paginated report, delivering altered parameters shouldn't be heavy at all. It achieves what users would others do slowly and manually via parameter settings on the report. 

Helpful resources

Announcements
Europe Fabric Conference

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