Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
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 👍.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.