cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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!

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors